dzmipt / kdbStudio

Studio for kdb+ / Rapid execution environment for q
Apache License 2.0
5 stars 7 forks source link

Export to Excel is time-zone sensitive #141

Closed demner closed 4 months ago

demner commented 6 months ago

If I have a table like ([]date:1#.z.d;msgTS:.z.p)

and I use the export to excel button then dates and times are converted to my local time zone so Excel shows incorrect values.

The export should be WYSIWYG with what's in the studio table

Note that we can use the "Copy selection (Excel format)" but that doesn't retain data type