How can surround the output from a to_char function in double quotes? I figured the following would work... but it does not.
Code: Select all
dbadmin=> select sysdate, to_char(sysdate, '"MM/DD/YYYY"');
sysdate | to_char
----------------------------+------------
2014-01-10 06:24:56.001893 | MM/DD/YYYY
(1 row)
Code: Select all
dbadmin=> select sysdate, '"' || to_char(sysdate, 'MM/DD/YYYY') || '"';
sysdate | ?column?
---------------------------+--------------
2014-01-10 06:26:55.50526 | "01/10/2014"
(1 row)