Difference between revisions of "DATE()"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return current system date or a date from specified year, month and day values | Function to return current system date or a date from specified year, month and day values | ||
| Line 46: | Line 42: | ||
==Products== | ==Products== | ||
| − | Recital | + | 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 16:38, 27 November 2009
Purpose
Function to return current system date or a date from specified year, month and day values
Syntax
DATE([<expN1>, <expN2>, <expN3>])
See Also
AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), ELAPTIME(), EMPTY(), EPOCH(), GOMONTH(), HOUR(), HOURS(), LTOS(), MDY(), MINUTE(), MINUTES(), MONTH(), MTOD(), MTOS(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, SET VAXTIME, STOD(), STR(), TIME(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), TYPE(), VAL(), VALIDTIME(), VTOD(), WEEK(), YEAR()
Description
The DATE() function returns the current system date as a date type. The display format of dates is affected by the SET CENTURY, SET DATE, SET EPOCH and SET MARK set commands.
The optional <expN1>,<expN2>,<expN3> can be used to specify numeric years, months and days and return a valid corresponding date. If any parameter is invalid, an empty date is returned.
| <expN1> | A valid number of years, -100 (1900) to 900 (2900) |
|---|---|
| <expN2> | A valid number of months, 1 to 12 |
| <expN3> | A valid number of days, 1 to 31 |
Example
? date() 04/04/2004 mdate = date() ? mdate 04/04/2004 ? type("mdate") D ? date(4,4,4) 04/04/2004
Products
Recital Server, Recital
