Hi, Ignite function EXTRACT (EPOCH from CURRENT_TIMESTAMP(3)) return seconds in future!!!
Current date and time on UNIX host, I am in Zagreb/Croatia CEST GMT+2 [root@incumbossdev01 ~]# date Fri Apr 17 10:51:10 CEST 2020 Connected to: Apache Ignite (version 2.7.6#20190911-sha1:21f7ca41) Driver: Apache Ignite Thin JDBC Driver (version 2.7.6#20190911-sha1:21f7ca41) Autocommit status: true Transaction isolation: TRANSACTION_REPEATABLE_READ sqlline version 1.3.0 0: jdbc:ignite:thin://192.168.50.95/> select CURRENT_TIMESTAMP(3); +--------------------------------+ | CURRENT_TIMESTAMP(3) | +--------------------------------+ | 2020-04-17 10:51:17.43 | +--------------------------------+ 1 row selected (0.032 seconds) https://apacheignite-sql.readme.io/docs/extract 0: jdbc:ignite:thin://192.168.50.95/> select EXTRACT (EPOCH from CURRENT_TIMESTAMP(3)); +------------------------------------------+ | EXTRACT(EPOCH FROM CURRENT_TIMESTAMP(3)) | +------------------------------------------+ | 1587120685.619 | +------------------------------------------+ 1 row selected (0.007 seconds) Convert EPOCH to Timestamp using https://www.epochconverter.com/ The current Unix epoch time is 1587113657 Assuming that this timestamp is in seconds: GMT: Friday, 17. April 2020 10:51:25.619 Your time zone: petak, 17. travanj 2020 12:51:25.619 GMT+02:00 DST Relative: In 2 hours Convert EPOCH to Timestamp using Postgres function postgres=# select to_timestamp(1587120685.619); to_timestamp ---------------------------- 2020-04-17 12:51:25.619+02 (1 row) -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
