Example: Querying the Wednesday Before the DATE or TIMESTAMP - Advanced SQL Engine

Example: Querying the Wednesday Before the DATE or TIMESTAMP - Advanced SQL Engine - Teradata Database

SQL Date and Time Functions and Expressions

Product

Advanced SQL Engine

Teradata Database

Release Number

17.10

Published

July 2021

Language

English (United States)

Last Update

2021-07-27

dita:mapPath

dzx1591742169550.ditamap

dita:ditavalPath

dzx1591742169550.ditaval

dita:id

B035-1211

lifecycle

Product Category

Teradata Vantage™

The following SQL statement:

SELECT TD_WEDNESDAY(TIMESTAMP'2012-05-08 10:00:00+01:00','ISO');

returns 2012-05-02 01:00:00+01:00.