The date stored in the Oracle database is a character string with a value of 13 digits, such as "1136836800000". Which

ahongwow

The date stored in the Oracle database is a character string with a value of 13 digits, such as "1136836800000". Which prawn knows what functions can be directly converted, thank you!

idpublic

to_date


"1136836800000" in which year and month?
Did not understand

ahongwow

Is an integer value that represents the number of milliseconds that have elapsed since midnight, January 1, 1970, Greenwich Mean Time (GMT). It is stored in the database through JSP program code.It is not known whether Oracle has a function in this area directly converted to a date, similar to the SetTime function.

海蓝之谜

Asidpublicsaid, first determine the correspondence between 1136836800000 and time before you know how to convert

海蓝之谜

SQL> select to_date ('1970/01/01', 'yyyy / mm / dd') + 1136836800000 / (1000 * 60 * 60 * 24) from dual;

TO_DATE ('1970/01/01', 'YYYY / MM /
------------------------------
January 9, 2006, 08:00:00 PM

ahongwow

OK, tks.

53203190

[Quote=Quote the reply from海蓝之谜on the 4th floor:]
SQL> select to_date( '1970/01/01','yyyy/mm/dd')+1136836800000/(1000*60*60*24) from dual;

TO_DATE( '1970/01/01','YYYY/MM/
------------------------------
January 9, 2006 08:00:00 PM
[/Quote] Not bad.!