user2846737
Reputation: 211
how to convert a number into timestamp in oracle/sql
how to convert a number into timestamp(6) in oracle? ie convert 20131108 to 08-NOV-13 12.00.00.000000 AM or any format in timestamp(6). Thanks!
Upvotes: 2
Views: 25536
Answers (1)
Thorsten Kettner
Reputation: 94859
You convert your number to a string with to_char. Then you convert that string to timestamp with to_timestamp. Time will automatically be midnight.
select to_timestamp( to_char(20131108) ,'yyyymmdd') from dual
Upvotes: 5
Related Questions
- Oracle timestamp string value conversion
- Oracle SQL convert number (that stores a timestamp) to human readable date time on select
- Convert to timestamp
- How do I convert a date timestamp in oracle to a date?
- How to convert a number (YYMMDDhhmmss) into timestamp in Oracle's SQL?
- How to convert Timestamp to Date column in Oracle?
- convert timestamp format to integer in oracle
- Oracle sql convert timestamp into format
- Timestamp conversion in Oracle SQL
- Convert timestamp to number format