Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
DBINFO Function
Using the 'utc_current' Option The 'utc_current' option returns the current value of Coordinated Universal Time (UTC) as an integer value that shows the number of seconds that have elapsed between 1970-01-01 00:00:00+00:00) and when the current SQL statement began to execute.

Using the 'utc_current' Option

The 'utc_current' option returns the current value of Coordinated Universal Time (UTC) as an integer value that shows the number of seconds that have elapsed between 1970-01-01 00:00:00+00:00) and when the current SQL statement began to execute.

Unlike Universal Time (UT), which calculates the duration of seconds from the earth's rotation, UTC uses seconds of a fixed length, based on high-precision atomic clocks.

Because of variation in the earth's gradually diminishing rotation rate, intercalary leap seconds are introduced from time to time in UTC to reduce discrepancies with UT time. By default, HCL OneDB™ ignores leap seconds in DATETIME and INTERVAL arithmetic. When HCL OneDB is supported by an operating system that takes leap seconds into account, however, the leap seconds are reflected in subsequent DATETIME and INTERVAL operations after the operating system adjusts the system clock for leap seconds.