sql - How to parse a string to a date, when the string has a character in it? -

i'm trying parse 2015-07-09t12:22:29 using to_date using following date format yyyy-mm-ddthh:mi:ss, i'm getting message date format not recognized.

you have put t in double quotes, yyyy-mm-dd"t"hh:mi:ss.

select to_date( '2015-07-09t12:22:29', 'yyyy-mm-dd"t"hh:mi:ss' ) dual;  to_date(' --------- 09-jul-15 

here's relevant documentation. (thanks alex)