Returns wrong result when query MySQL 4.1

Hi,
When running the following query "select TIMEDIFF('2004-04-28 04:11:00', '2004-04-28 04:58:00')" from Report Server connecting to MySQL 4.1 (using MySQL ODBC 3.51) returns 00:00:00. I ran the same query from MySQL gets the correct result -00:47:00. Why is that?
Your input is appreciated.
JLReporting Services does not modify the query commandtext - it is just passed
on to the ODBC provider.
When you run the query directly on MySQL you did not connect through the
MySQL ODBC provider, did you? Can you just write a minimal application that
uses the MySQL ODBC provider and execute the query - what is the result
there?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"jcl_tw" <jcl_tw@.discussions.microsoft.com> wrote in message
news:F845F342-D356-4534-BDC3-A9D1F6C9F36E@.microsoft.com...
> Hi,
> When running the following query "select TIMEDIFF('2004-04-28 04:11:00',
'2004-04-28 04:58:00')" from Report Server connecting to MySQL 4.1 (using
MySQL ODBC 3.51) returns 00:00:00. I ran the same query from MySQL gets the
correct result -00:47:00. Why is that?
> Your input is appreciated.
> JL|||Hi Robert,
When I ran the command on MySQL, it was running directly on the server, not thruogh MySQL ODBC. I have created few reports on RS connecting through MySQL ODBC and didn't receive bad data, this is the first, and this is the first report I'm using the time function.
JL
"Robert Bruckner [MSFT]" wrote:
> Reporting Services does not modify the query commandtext - it is just passed
> on to the ODBC provider.
> When you run the query directly on MySQL you did not connect through the
> MySQL ODBC provider, did you? Can you just write a minimal application that
> uses the MySQL ODBC provider and execute the query - what is the result
> there?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "jcl_tw" <jcl_tw@.discussions.microsoft.com> wrote in message
> news:F845F342-D356-4534-BDC3-A9D1F6C9F36E@.microsoft.com...
> > Hi,
> >
> > When running the following query "select TIMEDIFF('2004-04-28 04:11:00',
> '2004-04-28 04:58:00')" from Report Server connecting to MySQL 4.1 (using
> MySQL ODBC 3.51) returns 00:00:00. I ran the same query from MySQL gets the
> correct result -00:47:00. Why is that?
> >
> > Your input is appreciated.
> > JL
>
>