The LOCALTIMESTAMP Function
Syntax for the LOCALTIMESTAMP function:
seconds-precision is an unsigned integer value denoting the seconds precision for the returned TIME value.
- The result is the current date and time as a TIMESTAMP value.
- The value of seconds-precision must be between 0 and 9.
- If seconds-precision is not specified, the default value of 6 is assumed.
- In any given SQL statement, all references to LOCALTIMESTAMP are effectively evaluated simultaneously from a single reading of the server clock. Thus the conditional expression LOCALTIMESTAMP = LOCALTIMESTAMP is guaranteed to always evaluate to true.
- In any given SQL statement, the value of LOCALTIMESTAMP will always be equal to the combined value of CURRENT_DATE and LOCALTIME.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40