Archives of the TeradataForum
Message Posted: Wed, 08 Dec 2004 @ 15:52:39 GMT
| Subj: | | Re: View the date field in dbc.oldpasswords table |
| |
| From: | | Dieter Noeth |
Victor Sokovin wrote:
| | Does this mean that TD counts days since something like 1 March 1 BC? | |
Yes, it's 307 days before 0001-01-01
| | I am a bit lazy to calculate the exact day. Interesting start date. | |
Don't ask why they choose it ;-)
I forgot a NULLIF in my first post, it's:
sel
date '0001-01-01' + ((NULLIF(DBASE.PasswordChgDate, 0)) - 307)
from dbc.dbase
Dieter
| 
