| |

VerySource

 Forgot password?
 Register
Search
View: 7|Reply: 5

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

[Copy link]

1

Threads

3

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 China

Post time: 2020-1-15 18:40:01
| Show all posts |Read mode
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!
Reply

Use magic Report

0

Threads

39

Posts

23

Credits

Newbie

Rank: 1

Credits
23

 China

Post time: 2020-1-23 22:54:01
| Show all posts
to_date


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

Use magic Report

1

Threads

3

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 China

 Author| Post time: 2020-1-24 15:09:02
| Show all posts
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.
Reply

Use magic Report

0

Threads

10

Posts

6

Credits

Newbie

Rank: 1

Credits
6

 Invalid IP Address

Post time: 2020-1-24 15:18:01
| Show all posts
Asidpublicsaid, first determine the correspondence between 1136836800000 and time before you know how to convert
Reply

Use magic Report

0

Threads

10

Posts

6

Credits

Newbie

Rank: 1

Credits
6

 Invalid IP Address

Post time: 2020-1-25 16:18:01
| Show all posts
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
Reply

Use magic Report

1

Threads

3

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 China

 Author| Post time: 2020-1-29 16:36:02
| Show all posts
OK, tks.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list