LOCALTIME SQL Function
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.
SELECT LOCALTIME(3) 'LOCALTIME' FROM admin.syscalctable;
1 record selected
The time_precision value is always set as three irrespective of what the user has specified and milliseconds is always returned as ‘000’.