Toad World® Forums

Export Dataset options number quoting for date


#1

When exporting dataset I use the following options for quoting:

  • String quoting: Double quote strings including nulls
  • Number quoting : Double quote strings including nulls

Unfortunately the dates are not quoted correctly:

“BARCODE”,“CHECKOUT_DATE”,“DUE_DATE”,“PATRON_ID”,“CHECKOUT_TYPE”,“LAST_NOTICE_DATE”,“RENEW_COUNT”,“NOTICE_COUNT”
“1901968082”,20.08.2018 ,24.09.2018 ,“50579”,“0”,“1”,“1”
“1900032405”,11.09.2018 ,06.11.2018 ,“8586”,“0”,“0”,“1”
“1900859302”,03.09.2018 ,01.10.2018 ,“39547”,“0”,“0”,“1”

Can somebody help me to figure out how to fix this?

Thanks
Bruce


#2

Try casting them to strings in your query with TO_CHAR.


#3

Thanks a lot! I used the following syntax:

TO_CHAR (CIRCDETL.CHECKOUT_DATE)

and it worked!

Best,
Bruce