search

antares-sql / antares

A modern, fast and productivity driven SQL client with a focus in UX
https://antares-sql.app
MIT License
1.6k stars 111 forks source link

Export CSV without any transformations, maintaining the original format of dates and other fields. #776

Closed abcRede closed 2 months ago

abcRede commented 3 months ago

Is your feature request related to a problem? Please describe. I frequently encounter the issue of exporting data that includes date fields. However, upon export, these dates are formatted in a manner that makes it difficult to parse them in other applications.

Example: image

Output (CSV)

.expected;s.actual
2024-03-11 17:24:25;Mon Mar 11 2024 17:24:25 GMT-0300 (Horário Padrão de Brasília)
2024-03-11 17:24:25;Mon Mar 11 2024 17:24:25 GMT-0300 (Horário Padrão de Brasília)
2024-03-11 17:22:06;Mon Mar 11 2024 17:22:06 GMT-0300 (Horário Padrão de Brasília)
2024-03-11 17:22:06;Mon Mar 11 2024 17:22:06 GMT-0300 (Horário Padrão de Brasília)
2024-03-11 17:20:56;Mon Mar 11 2024 17:20:56 GMT-0300 (Horário Padrão de Brasília)

This format cannot be parsed back, and it is also dependent on locale.

Describe the solution you'd like I would like the option (or default behavior) to export the dates as they are, without any transformation.

Describe alternatives you've considered Currently, I manually format all queries to output the date field as a string.

Additional context I'm using PT-BR language.

Fabio286 commented 3 months ago

Fixed 65ec4c5da6187a7ab2dfff59326cd12bfa788c3b