Appearance

GET_DBSERVER_TIMESTAMP ​

GET_DBSERVER_TIMESTAMP returns the current server date and time as a string. The returned timestamp depends on the time settings on the database server.

Syntax ​

leo-grammar
CC "DB" GET_DBSERVER_TIMESTAMP	

#--> RESULT ecode:intValue errtext:strValue timestamp:strValue
CC "DB" GET_DBSERVER_TIMESTAMP	

#--> RESULT ecode:intValue errtext:strValue timestamp:strValue

Parameters ​

none

Returns ​

  • ecode (intValue) - Contains the error code or 0 in case of success.
  • errtext (strValue) - contains a textual representation of the ecode.
  • timestamp (strValue) - has THE format "yyyy-mm-dd,hh:MM:ss".

Details ​

  • ecode (intValue) - Contains the error code or is 0 in case of success.
    errtext - strValue, contains a textual representation of the ecode.
    timestamp - strValue; has THE format "yyyy-mm-dd,hh:MM:ss".

See Also ​

Examples ​

asc
CC "DB" GET_DBSERVER_TIMESTAMP
CC "AdoScript" INFOBOX ("The current server timestamp is: " + timestamp)
CC "DB" GET_DBSERVER_TIMESTAMP
CC "AdoScript" INFOBOX ("The current server timestamp is: " + timestamp)

Versions and Changes ​

Available since ADOxx 1.3