MONTH

Applies to

Description

Returns an integer that represents the month of the specified date. ().

MONTH( date )

MONTH ( <date_or_timestamp_expr> )

Code:

IN -> SqlServer_01.sql

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

Result:

MONTH|
-----+
   10|

Code:

OUT -> SqlServer_01.sql

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

Result:

MONTH|
-----+
   10|

No issues were found.

No related EWIs.

Last updated 3 months ago