search

wagonhq / feedback

A place to discuss Wagon features and fixes, join us on Slack at
http://band.wagonhq.com
6 stars 0 forks source link

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

Open hernamesbarbara opened 8 years ago

hernamesbarbara commented 8 years ago

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

image

3 paste the data into excel

expect => pasted data should look reasonable.

actual => pasted data goes into excel wonky

image

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.

hernamesbarbara commented 8 years ago

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