DAY

Description

This function returns an integer that represents the day (day of the month) of the specified date. (DAY in Transact-SQL).

Sample Source Pattern

Syntax

SQL Server

DAY ( date )  

Snowflake SQL

Snowflake SQL Documentation

DAY( <date_or_timestamp_expr> )

Examples

SQL Server

Code:

SELECT DAY('10-10-2022') AS DAY

Result:

DAY  |
-----+
   10|

Snowflake SQL

Code:

SELECT DAY('10-10-2022' :: TIMESTAMP) AS DAY;

Result:

DAY  |
-----+
   10|