 |
 |
Archives of the TeradataForum
Message Posted: Wed, 08 Dec 2004 @ 15:00:18 GMT
| Subj: | | Re: View the date field in dbc.oldpasswords table |
| |
| From: | | Victor Sokovin |
| | By using SYS_CALENDAR.CALENDAR.DAY_OF_CALENDAR and DBC.USERS. PasswordLastModDate, I believe that I proved (I had no differences in my
active users) that the following would work: | |
select username, calendar_date
from dbc.oldpasswords
, sys_calendar.calendar
where day_of_calendar = passworddate - 693901
order by 1;
Does this mean that TD counts days since something like 1 March 1 BC? I am a bit lazy to calculate the exact day. Interesting start
date.
Regards,
Victor
| |
