Hello! I guess that EPOCH() returns -- Ilya Kasnacheev
пт, 17 апр. 2020 г. в 12:07, dbutkovic <[email protected]>: > 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/ >
