Valid Input Syntax for Type DATE

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Valid Input Syntax for Type DATE
Date: 2012-02-29 17:49:03
Message-ID: alpine.LNX.2.00.1202290945200.15032@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to insert rows into a table, but some date and time columns are
missing values. In the INSERT INTO ... statements of the .sql file I've
tried various formats: ,, and ,'', and ,' ', but they all generate the error
of invalid syntax for type date.

When I have missing date of the date and time types, how do I validly
represent them in the input file?

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-02-29 17:53:55 Re: what Linux to run
Previous Message sujayr06 2012-02-29 17:14:54 PQputCopyData buffer limit