Archives of the TeradataForum
Message Posted: Wed, 14 Feb 2001 @ 15:03:17 GMT
I don't know about the DateDiff perl function, but the value your seeing is (relatively) easy to explain. It is the value that Teradata stores internally for today's date. This internal format is also the default format that Teradata uses to return DATE values to a program. This can be over-ridden in different ways depending on what you want to achieve, but that's the default.
The break down is;
For today's date that is;
1010000 + 200 + 14 = 1010214
This may seem strange to you if you're new to Teradata, but that's the way it is.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|