DAY: Obtaining the Day of the Month From a Date/Timestamp

How to:

The DAY function returns the day of the month from a date or timestamp value.


Top of page

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

where:

arg

Date or timestamp

Is the input value.

This function returns an integer value.



Example: Obtaining the Day of the Month From a Date or Timestamp

DAY returns the day of the month from a date or timestamp. This example,

DAY('1976-07-04')

returns 4.

This example,

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

returns 22.


iWay Software