Difference between revisions of "TIMESTAMP()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return the current system date and time | Function to return the current system date and time | ||
− | |||
==Syntax== | ==Syntax== | ||
TIMESTAMP() | TIMESTAMP() | ||
− | |||
==See Also== | ==See Also== | ||
[[CDOW()]], [[DATE()]], [[DAY()]], [[DOW()]], [[DTOS()]], [[MONTH()]], [[SECONDS()]], [[SECS()]], [[STOD()]], [[TIME()]], [[WEEK()]], [[YEAR()]] | [[CDOW()]], [[DATE()]], [[DAY()]], [[DOW()]], [[DTOS()]], [[MONTH()]], [[SECONDS()]], [[SECS()]], [[STOD()]], [[TIME()]], [[WEEK()]], [[YEAR()]] | ||
− | |||
==Description== | ==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. | 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== | ==Example== | ||
Line 19: | Line 15: | ||
update_time = timestamp() | update_time = timestamp() | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== |
Revision as of 11:20, 12 December 2012
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
Lianja, Lianja Server