sql - What is the best way to escape non-format characters in Oracle's to_char?

Question

posted Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

I am trying to print a date in a select statement, but I need to add a letter to the output:

to_char(date_updated, 'YYYY-MM-DDTHH:mm:ss')

Oracle does not like the T. I just want the T to be output like the colons and the dashes. Can I escape it with a backslash or something?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

1 Reply

深蓝 · Answer 1 · 2021-10-23T18:38:53+0000

replyed Oct 24, 2021 by 深蓝 (71.8m points)

You just need double-quotes around it:

to_char(date_updated, 'YYYY-MM-DD"T"HH:mm:ss')

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…