Eclipse Community Forums: BIRT » Anyone see why this should fail?

Home » Archived » BIRT » Anyone see why this should fail?

Anyone see why this should fail? [message #144451]

Thu, 16 March 2006 07:40

Eclipse User

Originally posted by: andy.nospam.com

I have a MySQL query where I want a difference in times between two dattime
fields. In testing, if I run this query in a MySQL client application (not
Birt)...

SELECT TIMEDIFF('2006-02-24 09:59:31','2006-02-01 00:00:00') as tdiff

then I get a result - 561:59:31.

If I run the exact same query in Birt, and try and preview the result, I get
the following error:

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.0.1
Error Code:odaconsumer.CannotGetTimeFromColumn
Error Message:Cannot get the time value from column: 1
Cannot get time value in the result set.
java.sql.SQLException

Anyone know why?

Andy

Re: Anyone see why this should fail? [message #144479 is a reply to message #144451]

Thu, 16 March 2006 08:25

Eclipse User

Originally posted by: rebprotizer_2k3.hotmail.com

Why don't you use the expression system of birt.
first recover your minutes and after do a difference.

row["YourDate"].getTime()

;-)

Re: Anyone see why this should fail? [message #144497 is a reply to message #144479]

Thu, 16 March 2006 09:46

Eclipse User

Originally posted by: andy.nospam.com

Yeeesss....I suppose I could...
But it still doesn't explain why it doesn't work.

This gives the same error:

select sec_to_time(unix_timestamp('2006-02-24 10:59:31') -
unix_timestamp('2006-02-24 09:59:30'))
as elapsed

And it shouldn't. I think there may be a bug?

Andy

"Lucho" <rebprotizer_2k3@hotmail.com> wrote in message
news:d4d8a4c62b46671a8901e17ed85d882c$1@www.eclipse.org...
> Why don't you use the expression system of birt.
> first recover your minutes and after do a difference.
>
> row["YourDate"].getTime()
>
> ;-)
>

Previous Topic:	How to display the grid lines in the "Table"?
Next Topic:	accessing dataset

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 16 16:40:53 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter