更新时间:2022-12-28 10:16:30
Oracle文档:
您可以将这些字符包括在日期格式模型中:...字符文字,用双引号引起来
You can include these characters in a date format model: ...Character literals, enclosed in double quotation marks
所以
TO_CHAR(l.date_generated, 'yyyy/mm/dd"T"hh24:mi:ss')
如何添加字母"T"在日期和时间之间使用Oracle?