Date/Time Data Types
DATE represents a calendar date and simplifies handling and formatting
date variables, common to business applications. DATE is stored as an
integer, using this formula:
(year - 1900) * 10000 + (month * 100) + day
Warning: The Teradata DATE is not compatible with the DATE defined in
Intermediate level ANSI SQL.
No comments:
Post a Comment