Contents Index DATETIME function [Date and time] DAYNAME function [Date and time]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

DAY function [Date and time]


Function 

Returns an integer from 1 to 31 corresponding to the day of the month of a date.

Syntax 

DAY ( date-expression )

Parameters 

date-expression    The date.

Standards and compatibility 
Example 

The following statement returns the value 12.

SELECT DAY( '2001-09-12' )

Contents Index DATETIME function [Date and time] DAYNAME function [Date and time]