Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert milliseconds to date format in sql query

889885Sep 22 2011 — edited Sep 22 2011
Hi All,

The following code is in java.

String yourmilliseconds = "1316673707162";**
Date resultdate = new Date(Long.parseLong(yourmilliseconds));

could you plese tell me how to convert milliseconds into date format in query and comparing with another date like(sysdate-3)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2011
Added on Sep 22 2011
1 comment
14,011 views