CODEWITHSUNDEEP
oracle-databasedatetime
user729544
user729544

Reputation: 119

Oracle String to Date "2013-10-15T20:12:56.24584+0100"

I got a TIMESTAMP string, need to convert in Oracle to datetime, I try several format mask but fail, any idea?

to_timestamp('2013-10-15T20:12:56.24584+0100','YYYY-MM-DDTHH24:MI:SS.SSSSSTZHTZM')

Upvotes: 0

Views: 243

Answers (1)

Przemyslaw Kruglej
Przemyslaw Kruglej

Reputation: 8123

To get this right, you should:

  1. Use TO_TIMESTAMP_TZ function.
  2. Use FF format for fractional seconds instead of SSSSS.
  3. Enclose the literal T in quotation marks like this: "T".

This works:

SELECT
  TO_TIMESTAMP_TZ('2013-10-15T20:12:56.24584+0100','YYYY-MM-DD"T"HH24:MI:SS.FFTZHTZM')
FROM dual;

Upvotes: 3

Related Questions