Difference between revisions of "TIMESTAMP()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
Date and Time Data | Date and Time Data | ||
| Line 15: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[CDOW()]], [[DATE()]], [[DAY()]], [[DOW()]], [[DTOS()]], [[MONTH()]], [[SECONDS()]], [[SECS()]], [[ | + | [[CDOW()]], [[DATE()]], [[DAY()]], [[DOW()]], [[DTOS()]], [[MONTH()]], [[SECONDS()]], [[SECS()]], [[STOD()]], [[TIME()]], [[WEEK()]], [[YEAR()]] |
| Line 32: | Line 29: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Date and Time Data]] | ||
| + | [[Category:Date and Time Data Functions]] | ||
Revision as of 10:24, 2 June 2009
Class
Date and Time Data
Purpose
Function to return the current system date and time
Syntax
TIMESTAMP()
See Also
CDOW(), DATE(), DAY(), DOW(), DTOS(), MONTH(), SECONDS(), SECS(), STOD(), TIME(), WEEK(), YEAR()
Description
The TIMESTAMP() function is used for returning the current system date and time in a fixed format. The return value is a 19-character string in the format "YYYY.MM.DD hh:mm:ss". The return value is unaffected by the SET DATE, SET CENTURY and SET MARK settings.
Example
update_time = timestamp()
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
