ODBC blank date.time setting - Mailing list pgsql-odbc

From Barry Bell
Subject ODBC blank date.time setting
Date
Msg-id 4D51A19E0157604B94159573456A98FA25E4795E@BLUPRD0811MB413.namprd08.prod.outlook.com
Whole thread Raw
List pgsql-odbc

Hi:

    I am accessing Postgres from a lnageuage that supports blank dates (  vardatetime={} is a valid date in foxpro).

Postgres will produce an error with we try to insert a blank date into a timestamp.

(Getting the error: )

 

Is there any ODBC setting that will convert the blank date (vardatetime={} ) to a null value?

(Inserting null values into a timestamp works).

 

This language supports “views” for updated, used by the framework of our application,

 

Anyone have any idea if there ODBC setting to turn to blank date to null?

 

 

Thanks

Barry Bell, IT Department

 

pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: EN_Destructor bug
Next
From: Son Nguyen
Date:
Subject: bug in sqlGetInfo on Linux i386 platform