SqlDbx Forum

SqlDbx

You are not logged in.

#1 2010-09-02 02:18:13

timeco
Member

BIGINT export to excel

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

#2 2010-09-03 10:17:42

sqldbxhelp
Administrator

Re: BIGINT export to excel

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

Board footer

Powered by FluxBB