Archives of the TeradataForum
Message Posted: Wed, 14 Dec 2005 @ 10:42:39 GMT
Subj: | | Re: System Variables |
|
From: | | Dieter Noeth |
Koeby Johnson wrote:
| Where can I get a list of the Teradata System variables that will return information to me. For example: | |
> Select Date; Select User;
| What are the other ones that I can use? | |
ACCOUNT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DATABASE
DATE
PROFILE
ROLE
SESSION
TIME
USER
For details check
SQL Reference: Functions and Operators
CHAPTER 13 Built-In Functions
Dieter
|