All Forums Database
monisiqbal 119 posts Joined 07/09
01 Mar 2010
How to interpret value of field ‘CreateDate’ in TDWM tables?

CreateDate and RemoveDate are two fields in many of the tables related to TDWM e.g. in WlcDefs. The values and their meanings (according to me) are like:

1100301 - 2010/03/01 1091114 - 2009/11/14

What does the first '1' represent in these date fields? and is my interpretation correct?

dnoeth 4628 posts Joined 11/04
01 Mar 2010

Looks like a date in the internal Teradata format:
(year - 1900) * 10000 + month * 100 + day

110 + 1900 = 2010

Dieter

Dieter

monisiqbal 119 posts Joined 07/09
01 Mar 2010

Thanks for the response Dieter.
Is this your observation or is there a Teradata resource out there that states this fact?

You must sign in to leave a comment.