Date format for export?

Toad Data Point
1

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

2

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.