Toad World® Forums

Date format for export?

I’m sure I’m missing something simple. I’m outputting some data from an Editor in TDA and the date format in the resulting file (CSV) doesn’t match the displayed format. I can’t find a setting that I could use to change it to mm/dd/yyyy.

It’s DB2 v9.7, if it matters.

I’ve tried everything I can think of–any ideas on how I could change this?

Thanks for the help, Jeff

The date value will always be exported in universal format “yyyy-mm-dd” for compatiblity between different regional settings, you can use to_char() function to convert the date value to string so that the format does not apply.