Обсуждение: ODBC blank date.time setting

Поиск
Список
Период
Сортировка

ODBC blank date.time setting

От
Barry Bell
Дата:

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

 

Re: ODBC blank date.time setting

От
barryrbell
Дата:
Thanks, but the Extra Opts = 0x8 is not working on odbc version 9.2,
What was the last version where it worked?




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/ODBC-blank-date-time-setting-tp5742318p5755860.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.