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!

Convert number to timestamp

sliderrulesDec 6 2010 — edited Dec 6 2010

Hi,

I have a number data type column in a table that stores timestamps in format hhmiss

For example

95338 - convert to 09:53:38
101816 - convert to 10:18:16
123456 - convert to 12:34:56
83417 - convert t0 08:34:17

Can anyone recommend the best way to convert the number format to timestamp(hh:mi:ss). The problem seems to lie with numbers < 10 as they are missing a zero e.g. 95338

Thanks

This post has been answered by 821396 on Dec 6 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 3 2011

Added on Dec 6 2010

5 comments

8,210 views