15.00 - DATE/TIME - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

DATE/TIME

Purpose  

The DATE or TIME command shows the current system day, date, and time.

Syntax  

Usage Notes  

The DATE or TIME command shows a timestamp in the following format:

DDD mmm dd, yyyy HH:MM:SS

where:

 

Format …

Specifies …

DDD

the day of the week.

mmm dd, yyyy

the calendar month, day, and year.

HH:MM:SS

the time in hour, minutes, and seconds.

Example  

Example outputs generated by Ferret are shown below:

Ferret ==>
date
Tue Jun 13, 2000 12:04:58
 
Ferret ==>
time
Tue June 13, 2000 12:06:15