Difference between revisions of "DAY()"

From Lianjapedia
Jump to: navigation, search
Line 28: Line 28:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:Date and Time Data]]
 
 
[[Category:Date and Time Data Functions]]
 
[[Category:Date and Time Data Functions]]

Revision as of 11:37, 4 February 2013

Purpose

Function to return the day of the month from a specified date or datetime

Syntax

DAY(<expD> | <expT>)

See Also

AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), ELAPTIME(), EPOCH(), GOMONTH(), HOUR(), HOURS(), ISLEAPYEAR(), MDY(), MINUTE(), MINUTES(), MONTH(), MTOD(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, STOD(), TIME(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), VALIDTIME(), VTOD(), WEEK(), YEAR()

Description

The DAY() function returns the day of the month from the specified date expression <expD> or datetime expression <expT> as a numeric value.

Example

? day({01/01/2004})
         1
store day({01/01/2004}) to m_Day
? m_Day
         1
m_Day = day(date())
? type("m_Day")
N
 
? day({10/10/2004 10:15:43 AM})
        10