Insert NULL date field

From: Rick Rosque <rrosque(at)flash(dot)net>
To: pgsql-questions(at)postgreSQL(dot)org
Subject: Insert NULL date field
Date: 1999-04-21 01:49:47
Message-ID: 371D2F73.A94A0275@flash.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have a table in postgresql 6.4.2 that has date fields. I'm trying to
insert a null into the date field and cannot find any docs on how to do
this. Can someone please give me some help.

insert into employee ( empnumber, hiredate, terminationdate ) values (
4, '04/19/99', NULL )

the above NULL does not seem to work.

Thanks in advance

Browse pgsql-general by date

  From Date Subject
Next Message Guo Ge 1999-04-21 02:12:34 tracking postgres
Previous Message Taravudh Tipdecho 1999-04-21 00:09:02 unsubscribe