Example: Rounding the Date to the Beginning of the Next Month - Teradata Vantage - Analytics Database

SQL Date and Time Functions and Expressions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
cpk1628111786971.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
pxz1544241488545
lifecycle
latest
Product Category
Teradata Vantageā„¢

The following query:

SELECT ROUND(CAST('2003/09/15' AS DATE), 'MONTH') (FORMAT 'yyyy-mm-dd'); 

returns the result 2003-09-01. Since the day is less than 16, the date returns to the beginning of the beginning of the month.

The following query:

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

returns the result 2003-10-01. Since the day is greater than or equal to 16, the date is rounded to the beginning of the next month.