the date value 0001-01-01 gets converted to ############## after exporting to csv

[Swarup_MOA]

Hi,

We have a date field in sqldb, where null is represented as 0001-01-01. When this value is exported to csv (manually  and via nprinting ), the value becomes  a long string of #################. 

Can we retain the same value ( 0001-01-01) in csv ?

Thanks

Swarup

[marcus_sommer]

Did you really look on the data with an editor like Notepad++? A csv-file is not an Excel even if Excel could open it and showing any own-interpreted results.