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
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.