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/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

On 2011-03-04 15:10, Chris Purves wrote:
> 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.
>

I was able to solve the problem by enabling the option "Treat BIGINT columns as INT columns". I don't know if this was a problem with the ODBC connector or with the LabVIEW SQL functions, but it's working now.

--
Chris Purves

--
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