[IGNITE-22350] Sql. Datetime functions ignore the precision. - ASF JIRA

XML

Word

Printable

JSON

According to 6.36 <datetime value function>:

If specified, <time precision> and <timestamp precision> respectively determine the precision of
the time or timestamp value returned.

the same for :
CURRENT_TIME
LOCALTIME
CURRENT_TIMESTAMP
LOCALTIMESTAMP

for now SELECT LOCALTIME(2) returns: 08:57:46.643

starting point : ItFunctionsTest#testCurrentDateTimeTimeStamp

Discovered while testing

IGNITE-21971 Extend test coverage for SQL F051-07(Basic date and time. LOCALTIME)

IGNITE-21972 Extend test coverage for SQL F051-08(Basic date and time. LOCALTIMESTAMP)