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

Examples

SQL Server

Code:

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

Result:

DAY  |
-----+
   10|

Snowflake SQL