How to interpret value of field ‘CreateDate’ in TDWM tables?

Database
Enthusiast

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?
Tags (2)
2 REPLIES
Junior Contributor

Re: How to interpret value of field ‘CreateDate’ in TDWM tables?

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

110 + 1900 = 2010

Dieter
Enthusiast

Re: How to interpret value of field ‘CreateDate’ in TDWM tables?

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