|
|
|
LOCALTIME SQL Function
Syntax
LOCALTIME([time_precision])
Description
The scalar function LOCALTIME returns current time as TIME value. This function takes an optional argument which decides the milliseconds precision in the result. The optional argument is an integer ranging between 0 and 3.
FairCom DB SQL statements can refer to LOCALTIME anywhere they can refer to a TIME expression.
Example
SELECT LOCALTIME(3) 'LOCALTIME' FROM admin.syscalctable;
LOCALTIME
-----------
12:34:000
1 record selected
Details
The time_precision value is always set as three irrespective of what the user has specified and milliseconds is always returned as ‘000’.
