Crystalguru
Technical User
Is there a reserved word in Teradata for system date? Similair to MSSQL sysdate?
thanks
thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
System Date
- Thread starter Crystalguru
- Start date
- Status
ANSI SQL requires support for
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
And teradata is ANSI compilant in this area. If you uses these terms in your SQL your queries will work on any ANSI compliant system without any change.
Teradata SQL also allows
DATE
TIME
I am not sure about TIMESTAMP. These are Teradata Specific and may not work on other platforms.
- Thread starter
- #3
Crystalguru
Technical User
THANKS!
New to teradata! Didn't realize I could rely on the ole ansi standards! Whew. All is not to new.
New to teradata! Didn't realize I could rely on the ole ansi standards! Whew. All is not to new.
- Status
