How to specify date format for csv export


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


Comment actions Permalink

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

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')

Please sign in to leave a comment.