This content has been marked as final. Show 4 replies
CAST is great for that:
SELECT CAST (created_time AS TIMESTAMP) AS created_timestamp FROM order_tbl;
I hope this answers your question.
If not, post a little sample data (CREATE TABLE and INSERT statements, relevant columns only) for all tables, and also post the results you want from that data.
Explain, using specific examples, how you get those results from that data.
+1 for CAST.
TO_TIMESTAMP could work, but it takes a VARCHAR2 which complicates things a little.
CAST it is, and it works for me.