Difference between revisions of "DAY()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
==Class==
 
Date and Time Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return the day of the month from a specified date or datetime
 
Function to return the day of the month from a specified date or datetime
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[AMPM()]], [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[CTOT()]], [[DATE()]], [[DATETIME()]], [[DAYS()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[ELAPTIME()]], [[EPOCH()]], [[GOMONTH()]], [[HOUR()]], [[HOURS()]], [[MDY()]], [[MINUTE()]], [[MINUTES()]], [[MONTH()]], [[MTOD()]], [[QUARTER()]], [[SEC()]], [[SECONDS()]], [[SECS()]], [[SET CENTURY]], [[SET DATE]], [[SET EPOCH]], [[SET HOURS]], [[SET MARK]], [[SET SECONDS]], [[SET VAXTIME]], [[STOD()]], [[TIME()]], [[TIMESTAMP()]], [[TSTRING()]], [[TTOC()]], [[TTOD()]], [[VALIDTIME()]], [[VTOD()]], [[WEEK()]], [[YEAR()]]
+
[[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]], [[SET VAXTIME]], [[STOD()]], [[TIME()]], [[TIMESTAMP()]], [[TSTRING()]], [[TTOC()]], [[TTOD()]], [[VALIDTIME()]], [[VTOD()]], [[WEEK()]], [[YEAR()]]
  
 
==Description==
 
==Description==
Line 35: Line 31:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:Date and Time Data]]
 
[[Category:Date and Time Data]]
 
[[Category:Date and Time Data Functions]]
 
[[Category:Date and Time Data Functions]]

Latest revision as of 15:03, 1 July 2011

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, SET VAXTIME, 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


Products

Recital Server, Recital