Extract Minute - 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

The standard date/time field extract function is supported for Minute, generating EXTRACT(MINUTE FROM date/time expression). If this function is applied to a column or expression of type other than Time or Timestamp, a SQL runtime error will occur. When dragging an Extract Minute function into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Date and Time > Extract Minute

Columns and/or other expressions/literals that resolve to a time or timestamp can be moved over the (empty) branch of the tree.

The type of the value returned is integer. There are no special properties for the Extract Minute function.