Valid Input Syntax for Type DATE - Mailing list pgsql-general

From Rich Shepard
Subject Valid Input Syntax for Type DATE
Date
Msg-id alpine.LNX.2.00.1202290945200.15032@salmo.appl-ecosys.com
Whole thread Raw
Responses Re: Valid Input Syntax for Type DATE
List 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



pgsql-general by date:

Previous
From: sujayr06
Date:
Subject: PQputCopyData buffer limit
Next
From: Scott Marlowe
Date:
Subject: Re: what Linux to run