Archives of the TeradataForum
Message Posted: Thu, 22 Nov 2007 @ 17:30:02 GMT
| Subj: | | Re: Between: not working as expected |
| |
| From: | | Dieter Noeth |
Anomy.Anom wrote:
| | I think there is some problem with how it is reading the blank dates. I am not sure what it is treating these blank dates as. | |
You run that query using SQL Assistant, it looks like a bug: If you set the "Display dates in this format" option to anything else but YYYY-MM-
DD, it blanks all dates before 0100-01-01.
So all the missing dates are 0001-01-01.
Just one more question: why do you still allow NULLs and default to NULL instead of DEFAULT DATE '0001-01-01'?
Dieter
| 
