Re: ODBC 3.51.11 // PowerBuilder Pipeline Reads Date Fields as VarChar(10)

[Simón Monge García]

I use PB 9.0.2 and Mysql ODBC Connector 3.51.11 too, and have a similar problem. This query:

SELECT a.description
INTO :ls_descripcion
FROM tabla a
WHERE :i_d_date BETWEEN a.ini_date AND a.end_date

works depending on the computer I'm using. In all computers have been installed Mysql ODBC Connector 3.51.11. IF I convert i_d_date variable to a string variable and format it just to look like Mysql date format, it works properly!!!

Are there anyone who can help me?

Thanks in advance!!