Examples | TRUNC(Date) Functions | Teradata Vantage - Example: Returning a Date Value for the First Day of the Week - Advanced SQL Engine - Teradata Database

The following query:

SELECT TRUNC(CAST('2003/09/17' AS DATE), 'D') (FORMAT 'yyyy-mm-dd'); 

returns the result 2003-09-14. The date was truncated to the first day of that week.