YEAR

Applies to

Description

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

YEAR( date )

YEAR ( <date_or_timestamp_expr> )

Code:

IN -> SqlServer_01.sql

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

Result:

YEAR |
-----+
2022 |

Code:

OUT -> SqlServer_01.sql

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

Result:

YEAR |
-----+
2022 |

No issues were found.

No related EWIs.

Last updated 3 months ago