Truncate To Functions (Aster Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

These functions are only available when connected to an Aster database.

The Truncate To functions perform a truncate on the date/time stamp to the specified granularity. When dragging a Truncate To function into a variable, a tree element like the following is created.

Variable Creation > Input > Variables: SQL Elements pane - Date and Time > Truncate To Day

This example shows the Truncate To Day tree element. The following Truncate To functions share the same general structure.
Truncate To Functions
Function Description
Truncate To Day Truncates the date/time stamp to the day.
Truncate To Hour Truncates the date/time stamp to the hour.
Truncate To Minute Truncates the date/time stamp to the minute.
Truncate To Month Truncates the date/time stamp to the month.
Truncate To Second Truncates the date/time stamp to the second.
Truncate To Year Truncates the date/time stamp to the year.
Truncate To Century Truncates the date/time stamp to the century.
Truncate To Decade Truncates the date/time stamp to the decade.
Truncate To Microseconds Truncates the date/time stamp to the microsecond.
Truncate To Millennium Truncates the date/time stamp to the millennium.
Truncate To Milliseconds Truncates the date/time stamp to the millisecond.
Truncate To Quarter Truncates the date/time stamp to the quarter.
Truncate To Week Truncates the date/time stamp to the week.