1

Topic: Convert Quartz.NET BIGINT time to Oracle Date

Colleagues;
Someone knows as to transform Quartz.NET BIGINT time in normal  date and on the contrary?
For example, date of 10/3/2017 of 7:00:00 PM UTC+4 is stored in the DB table as number 1507042800000.
Question as from this number to receive required 10/3/2017 of 7:00:00 PM.
On the Internet  only the information as it it is possible in MS-SQL DateTime to transform , but for  the such does not transit.

2

Re: Convert Quartz.NET BIGINT time to Oracle Date

Similar the number of milliseconds is stored in a DB with 1970-01-01:

SELECT (TIMESTAMP ' 1970-01-01 0:00:00 AM UTC ' + NUMTODSINTERVAL (1507042800000 / 1000, ' SECOND ')) AT TIME ZONE ' +4:00'
FROM DUAL
/
(TIMESTAMP ' 1970-01-0100:00:00UTC ' +NUMTODSINTERVAL (1507042800000/1000, ' SECON
---------------------------------------------------------------------------
03-OCT-17 07.00.00.000000000 PM +04:00
SQL>

SY.

3

Re: Convert Quartz.NET BIGINT time to Oracle Date

Yes, really.
The same decision to me Vint already prompted.
Thanks!