Home > mailing lists

Postgres ODBC blank date - Mailing list pgsql-odbc

From	Barry Bell
Subject	Postgres ODBC blank date
Date	May 17, 2013 20:57:43
Msg-id	4D51A19E0157604B94159573456A98FA2E74BB51@BLUPRD0811MB413.namprd08.prod.outlook.com Whole thread Raw
List	pgsql-odbc

Hi:

Currently when we put a blank date into a date/time field in postgres, we get a “Invalid data/time syntax” error.

Can you put a patch for the ODBC driver to convert the blank date to null?

(Other ODBC drivers we are doing do this and a previous ODBC drive 7.3.260 did support this?

Any way to add this to current version?

Thanks

Barry Bell, IT Department

Office: 954-429-3771 x267 Fax: 954-281-1464 email Barry_Bell@harte-hanks.com

From: ljwilson
Date: 17 May 2013, 15:16:53
Subject: Re: Vote Release number of the next.

From: Hiroshi Inoue
Date: 18 May 2013, 01:38:04
Subject: Re: ODBC Blank Date convert to null