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

sql oracle to-char
Sixty4Bit picture Sixty4Bit · Feb 26, 2009 · Viewed 11k times · Source

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?

Answer

Chad Birch picture Chad Birch · Feb 26, 2009

You just need double-quotes around it:

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

Related questions

SQL to_char Currency Formatting

I am facing a to_char() currency formatting problem here. The below code is working for me: SELECT TO_CHAR(10000,'L99G999D99MI', 'NLS_NUMERIC_CHARACTERS = ''.,'' NLS_CURRENCY = $') "Amount" FROM DUAL; which will provide me with …

Read More
Oracle Time Comparisons

Is Oracle (10g) doing a proper TIME comparison here, or do I need to convert to decimal time and then compare? E.g., IF (SELECT TO_CHAR(sysdate,'HH24:MI:SS') from dual) <= '15:00' THEN (...) Thanks.

Read More
how to display number value in words

Q. Display the number value in Words and output should look like this SAL In_Words --------- ----------------------------------------------------- 800 eight hundred 1600 one thousand six hundred 1250 one thousand two hundred fifty And, I'm still didn't figure out, how this query is the …

Read More