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.

c-treeACE 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’.