How to view date using sql

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

josh3006 - 20 Jan 2006 02:44 GMT

Hi ther
I'm new in DB2, currently i'm into java developmen
The problem that i'm facing is that when i use JSP page to save, th
date is correct when i pass(from JSP page) to database, but when
checked inside the database the date stored is different than what
passed or saved into the datbase. Can anyone have idea on this
If possible, how can i see the server time using DB2 sql command
i have tried now(),getDate,.. and so on..
Can anyone assist me on this proble
Thank

Reply to this Message

Mark A - 20 Jan 2006 02:53 GMT

> Hi there
> I'm new in DB2, currently i'm into java development
[quoted text clipped - 6 lines]
> Can anyone assist me on this problem
> Thanks

Date columns are always stored internally within DB2 the exact same way,
regardless how it is sent to DB2 for storage. The internal format is YYYMMDD
in packed decimal without sign bits, using a total of 4 bytes (2 numbers per
byte).

The retrieval display format differs depending on the language and country
code of the database server and/or the client. The display format always has
separators such as dashes, slashes, periods, etc depending on which
language/country code. The total length of display format is 10 bytes
character.

You can change the display format for the date from the default of your DB2
installation by using the CHAR command as described in the SQL Reference Vol
1. There are several defined formats to choose from such as ISO, USA, etc.

Reply to this Message

josh3006 - 20 Jan 2006 03:05 GMT

Hi all, sorry on the doub
I have resolve it
The DB2 saving with
MM/DD/YYYY forma

all this while i was sending as DD/MM/YYY

Reply to this Message

Tonkuma - 20 Jan 2006 10:20 GMT

You can use another formats too.(The point is delimiter character.)
DD.MM.YYYY or YYYY-MM-DD

Reply to this Message