|
SQL Drill Add-in -
FAQ
|
|
Saturday, 28 March 2009 15:05 |
|
This is an FYI on the MYSQL DATE. It is specific to MYSQL as far as I know and it a limitation of the ADO library. Basically, the ADO library does not do a good job of handling the DATE type that MYSQL uses.
So as an example - this will not work and will return a record set of 0 records when there are are records in the table.
| Code: |
Select Some_Table.Some_MYSQL_Date_Field
From Some_Table
|
And you have to cast to get the records back like this
|
Code:
|
Select Cast(Some_Table.Some_MYSQL_Date_Field As DATE)
From Some_Table
|
The ADO library works really well and is extremely powerful but there are some limitations/issues like shown above.
SQL Drill Support
 |
