Toad World® Forums

DATE Format question


#1

Hi everyone,

i have a SQL script below

SELECT ITEM AS “ClassCode”,
Appdate AS “EstablishedDate”,

–> output to txt file from toad is for example : 1/1/2008 (without any single or double quotes)

However, according to the new format, i convert it to

SELECT ITEM AS “ClassCode”
TO_char(Appdate,‘YYYY-MM-DD’) AS “EstablishedDate”

–> output to txt file is for example : 1/1/2008 (without any single or double quotes) is : “2008-01-01” (This is what they want)–> how can i remove those double quote from script? or can i covert it to numeric value?

in database, there is no quote surrounded.

Thank you


#2

Hi, when you are expoting from TOAD make sure that the checkbox “Double-quote Char Columns” on the export options dialog, this should remove the double quotes on the date