TIMESTAMP
912971Mar 14 2012 — edited Mar 15 2012I am trying to insert timestamp values in the database,
e.g. 2012-02-21T10:15:01.000-06:00
insert into table1 (event_time)
values (TIMESTAMP '2012-02-21T10:15:01.000-06:00')
Error: ORA-01861: literal does not match format string
after replacing 'T' with ' ' in the timestamp value,
insert into table1 (event_time)
values (TIMESTAMP '2012-02-21 10:15:01.000-06:00')
it works fine.
What should I do to insert timestamp values with 'T'?
Thanks.