Hi,

I'm trying to pull some data from a MySQL 4.1 with the ODBC Driver using
Excel
and a parameter query like

select * from table where date > ?

with date as a datetime field.

I want the date parameter come from another excel cell. This doesn't
work and
I guess there is some Excel / ODBC conversion which results in a
datetime somehow
different than entered in excel.

Any help is appreciated.

Kind regards
Sven



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg

I don't know if this will help but you could try formatting the date as
'yyyymmdd hh:nn:ss'

cheers

mike

Peters, Sven wrote:

>Hi,
>
>I'm trying to pull some data from a MySQL 4.1 with the ODBC Driver using
>Excel
>and a parameter query like
>
>select * from table where date > ?
>
>with date as a datetime field.
>
>I want the date parameter come from another excel cell. This doesn't
>work and
>I guess there is some Excel / ODBC conversion which results in a
>datetime somehow
>different than entered in excel.
>
>Any help is appreciated.
>
>Kind regards
>Sven
>
>
>
>
>

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org