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

Database

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
N/A

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

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?