SqlDbx
You are not logged in.
Pages: 1
Hi,
I have a question about exporting result set containing BIGINT columns to excel. They seem to be exported as string, so I either have to CAST those columns to DECIMAL or convert it in excel manually. I tried all three exports available.
An example, when you use DATEDIFF (date1, date2) function in query, the result is a bigint number.
Thanks,
Goran
Offline
This is correct. The reason we do it this way is because Excel can
not handle BIGINT values correctly. Excel converts them to double
and you can loose precision.
Offline
Pages: 1