Archives of the TeradataForum

Message Posted: Wed, 08 Dec 2004 @ 10:31:12 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: View the date field in dbc.oldpasswords table

From:		Victor Sokovin

Does the dbc.oldpassword table store the values in Julian date format..?

The Teradata manuals call it Julian but the dates seem to be different from what the rest of the world means by Julian dates. For example, Oracle returns the following Julian date today:

     SELECT TO_CHAR(SYSDATE, 'J') FROM dual ;

     2453348

If NCR were counting from 01 Jan 0001 then their "Julian" date must have been something like this today:

     SELECT TO_CHAR(TO_DATE('00010101', 'YYYYMMDD'), 'J') FROM dual ;

     1721424

I make it 2453348 - 1721424 = 731924.

But the OP already has dates like 732042 or 732129 in the table, so it seems to mean that NCR might be counting days since some other date (BC). If this is indeed some fixed date then it should be possible to count (just once) the days between that date and 1 Jan 1900. Having that offset would provide an easy conversion of NCR Julian dates to the usual dates by using the day_of_calender column in sys_calendar.

Regards,

Victor