MONTH: Obtaining the Month From Date/Timestamp

How to:

The MONTH function returns the month field from a date or timestamp value.


Top of page

x
Syntax: How to Obtain the Month From a Date or Timestamp
MONTH(arg)

where:

arg

Date or timestamp

Is the input value.

This function returns an integer value.



Example: Obtaining the Month From a Date or Timestamp

MONTH returns the month from a date or timestamp. This example,

MONTH('1976-07-04')

returns 7.

This example,

MONTH('2001-01-22 10:00:00')

returns 1.


iWay Software