Date (Teradata Database) - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

The following table lists the available date functions, and a description of their purpose.

Embedded Services: Date Functions
Function Description
LAST_DAY Returns the date of the last day of month that contains date_timestamp_value.
NEXT_DAY Returns the date of the first weekday (day_value) that is later than the date specified by date_timestamp_value.
MONTHS_BETWEEN Returns the number of months between date_timestamp_value1 and date_timestamp_value2.
OADD_MONTHS Adds a specified date_timestamp_value to a specified num_months and returns the resulting date.
ROUND Returns date_value with the time portion of the day truncated to the unit specified by fmt (nearest day if omitted).
TRUNC Returns date_value with the time portion of the day rounded to the unit specified by fmt (nearest day if omitted).
See the Teradata Database SQL Functions, Operators, Expressions, and Predicates document, B035-1145, for a detailed overview of these date functions.