MONTH function [Date and time]

Function

Syntax

MONTH ( date-expression )

Parameters

date-expression A date/time value.

Example

The following statement returns the value 7:

SELECT MONTH( '1998-07-13' ) FROM iq_dummy

Standards and compatibility