Hi Jim,

Thanks for your response, yeah I was expecting it to be 0001-01-01.

Hi All, We are trying to load a table with a column having Datatype as 'DATE' and inserting the value 00000000, worked fine but when we query the table we are getting a suffix 'BC' as show below. Is there anyway we can avoid it? => copy PUBLIC.TEST (column1 format 'YYYYMMDD') from stdin ABORT ON ERR...