On 3/5/2015 8:34 PM, Medhavi Mahansaria wrote:
I need to enter the date in null column based on the results obtained.
but my date gets inserted as 01/01/0001 in postgresql 9.3 when there is no value.
I need to enter NULL in the column.
ummmmmm, it seems to work fine for me? you give us no clue how you're inserting this date field.
test=# create table test (calendar date);
CREATE TABLE
test=# insert into test (calendar) values (null);
INSERT 0 1
test=# select calendar, calendar IS NULL from test;
calendar | ?column?
----------+----------
| t
(1 row)
--
john r pierce 37N 122W
somewhere on the middle of the left coast