How to add letter "T" between date and time using Oracle?

Question

I want to add letter T between date and time using oracle

Like this:

2015/01/01T00:00:00

Script for date

to_char(l.date_generated, 'yyyy/mm/dd hh24:mi:ss')

Answer 1

Oracle docs:

You can include these characters in a date format model: ...Character literals, enclosed in double quotation marks

so,

TO_CHAR(l.date_generated, 'yyyy/mm/dd"T"hh24:mi:ss')