dashDB: how to create a TIMESTAMP from an ISO 8601 date?

Question

I have a VARCHAR field storing an iso 8601 date as follows: 2015-01-13T23:17:00

I would like to convert the date into a TIMESTAMP.

It seems that I have to strip out the 'T' to use the TIMESTAMP_FORMAT function:

SELECT
    T.F1,
    T.F2,
    TIMESTAMP_FORMAT(
        REPLACE(T."log_date", 'T', ' '), 'YYYY-MM-DD HH24:MI:SS'
    ) TS
FROM
   "MYSCHEMA"."MYTABLE" T

This feels a bit clumsy. What is the recommended way of parsing ISO 8601 dates in dashDB?

score 0 · Accepted Answer · edited May 23 '17 at 11:58

0

It seems that the approach I taken in dashDB although a bit kludgey but is similar to what others have recommended for DB2. See some answers for DB2, here.

edited May 23 '17 at 11:58

Community

1
1

answered May 20 '15 at 11:50

Chris Snow

23,813
35
144
309

dashDB: how to create a TIMESTAMP from an ISO 8601 date?

1 Answers1