`Copy Result Data` not super friendly when dealing with date / datetime

[austinogilvie]

1 Run a query that includes at least 1 date or time column.

e.g.

SELECT now() AS time_now , current_date AS todays_date;

2 copy data to clipboard in the UI

3 paste the data into excel

expect => pasted data should look reasonable.

actual => pasted data goes into excel wonky

Oh also - pasting Wagon data into Sheets totally works, so way to go Google.

Sad that Excel--the more established spreadsheet app--can't deal with dynamic data type discovery like Sheets.

[austinogilvie]

there might not be anything wagon can do to solve this UX issue but perhaps there's some export date format that both Sheets and Excel (and ideally Open Office) all know how to ingest and display properly...just figured i'd ask