SQL Assistant behaving weird

Database
Fan

SQL Assistant behaving weird

I have a date column with a value of '0001-01-01'. The columnd is defined in the table as:

DATE FORMAT 'YYYY-MM-DD' NOT NULL

SQL Assistant Version 7 displays it as blank whereas version 6.1 displays it properly. Is there
a setting I can do to fix it?
2 REPLIES
Enthusiast

Re: SQL Assistant behaving weird

Hi,

Tried the folowing :

sel cast(date '0001-01-01' as char(10))
o/p -- 0001-01-01

For all years < 0100 the output seems to be blank.

Strange .. something with the calculation of the date ?
Enthusiast

Re: SQL Assistant behaving weird

Please uncheck the option "use localized date display format" in Tools-->Options-->General tab