date and time functions not working

Hello,

Date and time functions are not working for me when using the ODBC connector with LabVIEW.  The following query works fine on the command line client on the server:

SELECT measurement_id, measurement_time, year(measurement_time) FROM measurements WHERE measurement_id = 84;

with the following result:

+----------------+---------------------+------------------------+
| measurement_id | measurement_time    | year(measurement_time) |
+----------------+---------------------+------------------------+
|             84 | 2010-01-08 15:35:25 |                   2010 |
+----------------+---------------------+------------------------+
1 row in set (0.00 sec)

When going through the MySQL ODBC connector I get no value returned for the YEAR function:

Value -> 84.000E+0
Value -> 08/01/2010 3:35:25 PM

Other seemingly simple queries don't work either: "SELECT 3" for example.

-- 
Chris Purves

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]