Period Timestamp (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

This function is only available when connected to a Teradata database.

A Period Timestamp literal may look like PERIOD ‘(2012-04-01 08:30:00 – 2012-04-30 13:00:00)’ where dates are in a year-month-day format and hours, minutes and whole seconds are displayed separated by colon characters, with hours displayed in a 24-hour format, so that this example represents 8:30 AM on April 1st to 1:00 PM on April 30th.
In keeping with Timestamp literals, fractions of a second and time zones are not supported. If either of these is desired, it is possible to use the Text Literal SQL element to include either or both of them. Also, Period Timestamp literals are not available as literal parameters, but again the Text Literal Parameter may be used to specify a Period Timestamp value as a literal parameter.