How to format a timestamp

Question

I have col1in myTable, which is equal varchar, and I need to insert a timestamp here, for example: - 09-MAY-11 10.23.12.0000 AM.

Now tell me:

+3

Avi May 11 '11 at 6:55

1 answer

schurik · Accepted Answer · 2011-05-11T08:02:40+0000

INSERT:

insert into myTable (col1) VALUES (to_char(systimestamp, 'dd-mon-yyyy hh.mi.ss.ff4 AM') );

SELECT

select to_timestamp(col1, 'dd-mon-yyyy hh.mi.ss.ff4 AM')  from myTable ;

But it is much better to store data directly as a timestamp. Then you can compare the values or change them directly.

create table myTable1( col1 timestamp default systimestamp);