Oracle gem of the day: literal text in date formats

jdavidb on 2005-06-07T13:45:24

To convert an ISO standard timestamp to an Oracle date, you want to use a date format string as in the following example:

TO_DATE('2005-06-07T13:28:36',
        'YYYY-MM-DD"T"HH24:MI:SS')

The new thing for me is figuring out how to embed that literal T into the format.