Skip to Main Content

SQL & PL/SQL

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 float to timestamp in single select query

d9193ab1-350b-4562-8f5c-e3c964bc0468Mar 18 2015 — edited Mar 18 2015

how to convert float to timestamp in single select query

for exp.  i have float as 1.251152515236 ,

i want to convert this to datetime and from datetime to timestamp... i.e.   26:11:00

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2015
Added on Mar 18 2015
7 comments
838 views