Problem in exporting data from BTQ to CSV

Database

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

Tags (4)