DAY

Applies to

Description

This function returns an integer that represents the day (day of the month) of the specified date. ().

DAY ( date )

DAY( <date_or_timestamp_expr> )

Code:

IN -> SqlServer_01.sql

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

Result:

DAY  |
-----+
   10|

Code:

OUT -> SqlServer_01.sql

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

Result:

DAY  |
-----+
   10|

No issues were found.

No related EWIs.

Last updated 2 months ago