Date Datatype Limitaion

ratheeshknair · #1 (**permalink**) 01-19-10, 02:43

Hi Experts,

Is there any limitation for DB2 in showing dates less than 01-01-1940 in DB2.

We are getting NULL values through application for dates less than 01-01-1940 and higher than 2039-12-31

TIA

tonkuma · #2 (**permalink**) 01-19-10, 03:21

In the manual "DB2 SQL Reference Volume 1"

Quote:

A date is a three-part value (year, month, and day). The range of the year part is
0001 to 9999. The range of the month part is 1 to 12. The range of the day part is 1
to x, where x depends on the month.

ratheeshknair · #3 (**permalink**) 01-20-10, 01:17

How to resolve this ??Any idea??

stolze · #4 (**permalink**) 01-20-10, 02:21

I'd say that your application has a problem and you need to fix it there.

schintala · #5 (**permalink**) 01-20-10, 15:01

There is no such date range limitation in accepting the data data type in DB2. Some thing to do with the application code. Take a look into it closely.

Lenny77 · #6 (**permalink**) 01-20-10, 15:16

Quote:

Originally Posted by ratheeshknair

Hi Experts,

Is there any limitation for DB2 in showing dates less than 01-01-1940 in DB2.

We are getting NULL values through application for dates less than 01-01-1940 and higher than 2039-12-31

TIA

Show your query, please....

Nulls are not possible in any case....

Lenny

dbzTHEdinosaur · #7 (**permalink**) 01-20-10, 15:28

more important,
show the create table statement and the system defaults for your date column,
the INSERT SQL used to add a row,
and any UPDATE SQL against the column.

Lenny77 · #8 (**permalink**) 01-20-10, 17:18

Quote:

Originally Posted by dbzTHEdinosaur

more important,
show the create table statement and the system defaults for your date column,
the INSERT SQL used to add a row,
and any UPDATE SQL against the column.

Agree with you ! Something wrong...

Lenny

Internet Services

Web Development

Digital Marketing

Consumer Tech