Problem while displaying data into CSV
Posted: Wed Jan 07, 2009 5:33 am
Hi all,
There is a column with datatype date in table,we are creating csv file as target and when tried to open csv file the records in same columns displaying as (00:00.0)instead of (2004-03-01 12:00:00 AM).
We have tried different ways by changing data type (Varchar, Date, Timestamp, Real, Nvharchar, Longvarchar) of the column in the csv file but result is same.
Can any one help me to solve it.
Thanks
There is a column with datatype date in table,we are creating csv file as target and when tried to open csv file the records in same columns displaying as (00:00.0)instead of (2004-03-01 12:00:00 AM).
We have tried different ways by changing data type (Varchar, Date, Timestamp, Real, Nvharchar, Longvarchar) of the column in the csv file but result is same.
Can any one help me to solve it.
Thanks