Re: #PERSONAL# Reg: date going as 01/01/0001

[John R Pierce <pierce@xxxxxxxxxxxx>]

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