How to specify date format for csv export

Answered

I want to export some table date to csv. For specific reasons i need a special date format in the output (yyyy-MM-dd'T'hh:mm:ss). I have defined it in the system settings

but Datagrip doesn't respect this setting. It always displays the date as "yyyy-MM-dd hh:mm:ss".

Do i miss something or is it not possible to change the date format.

Kind Reards

Andreas

2 comments
Comment actions Permalink

There is no such option at the moment. Here is related feature request, please follow and vote.

0
Comment actions Permalink

Had the same issue,
For now, you can resort to converting your date field to a character field with the appropriate format

to_char(date_field, 'yyyy-MM-dd'T'hh:mm:ss')
0

Please sign in to leave a comment.