Difference between revisions of "TIMESTAMP()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=TIMESTAMP()=
 
 
 
==Class==
 
Date and Time Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return the current system date and time
 
Function to return the current system date and time
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[CDOW()]], [[DATE()]], [[DAY()]], [[DOW()]], [[DTOS()]], [[MONTH()]], [[SECONDS()]], [[SECS()]], [[TIME()]], [[WEEK()]], [[YEAR()]], [[STOD()]]
+
[[CDOW()]], [[DATE()]], [[DAY()]], [[DOW()]], [[DTOS()]], [[MONTH()]], [[SECONDS()]], [[SECS()]], [[STOD()]], [[TIME()]], [[WEEK()]], [[YEAR()]]
  
  
Line 29: Line 22:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:Date and Time Data]]
 +
[[Category:Date and Time Data Functions]]

Latest revision as of 16:39, 8 December 2009

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, Recital Server