PRIOR Function | SQL Date/Time Functions & Expressions | Teradata Vantage - 17.00 - 17.05 - PRIOR - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Programming Reference
Publication ID
B035-1211-170K
Language
English (United States)

Returns the preceding value of the argument so that there is one granule of the argument type between the returned value and the argument.

Syntax

PRIOR ( datetime_expression )
datetime_expression
An expression that evaluates to a DATE, TIME, or TIMESTAMP value.