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.