YEAR/MONTH/DAYOFMONTH/HOUR/MINUTE/SECOND | Teradata Vantage - 17.10 - YEAR/MONTH/DAYOFMONTH/HOUR/MINUTE/SECOND - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1211-171K
Language
English (United States)

Returns the year, month, day of month, hour, minute, and second field from any DateTime or Interval value, converting it to an exact numeric.

ANSI Compliance

This statement is ANSI compliant, but includes non-ANSI Teradata extensions.

Result Type

For information about result type and attributes, see EXTRACT.