All Forums Database
raghav.garg 2 posts Joined 09/14
15 Jan 2015
Problem in exporting data from BTQ to CSV

Hello,
 
I am running a BTQ script which is generating a .CSV file.
One of the column in the file is a number but datatype for the same in the parent table is defined as CHAR.
I am using a cast function to convert it into bigint( number is 13 digits long), results are fine when I am running this query in SQL Assiatant.
But the CSV file is displaying the value as

2.8367E+12

I know that we can change it in CSV file itself but I would like to have this value as 2836700325000 directly when I open CSV.
Any help would be appreciated.
 
Raghav

You must sign in to leave a comment.