Inserting Date as 0000-00-00
Posted: Wed Jun 26, 2013 4:07 pm
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 ERROR delimiter '|' TRAILING NULLCOLS DIRECT NO ESCAPE;
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
>> 00000000
>> 00000000
>> \.
=> SELECT * from PUBLIC.TEST ;
column1
---------------
0001-01-01 BC
0001-01-01 BC
(2 rows)
Any help would be really appreciated.
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 ERROR delimiter '|' TRAILING NULLCOLS DIRECT NO ESCAPE;
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
>> 00000000
>> 00000000
>> \.
=> SELECT * from PUBLIC.TEST ;
column1
---------------
0001-01-01 BC
0001-01-01 BC
(2 rows)
Any help would be really appreciated.