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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.