Eclipse Community Forums: BIRT » Mysql query to prompt for start and end dates

Home » Archived » BIRT » Mysql query to prompt for start and end dates(Mysql query to prompt for start and end dates)

Show: Today's Messages :: Show Polls :: Message Navigator

Mysql query to prompt for start and end dates [message #690602]

Wed, 29 June 2011 19:59

Steve

Messages: 1
Registered: June 2011

Junior Member

Hello. I am new to the forum and relatively new to BIRT as well.

I'm trying to find the equivalent syntax of the following Oracle query snippet that prompts for start and end dates when a report is generated.

where session.created_on > to_date(?, 'YYYY-MM-DD')
and session.created_on < to_date(?, 'YYYY-MM-DD')
order by session.created_on asc

When I put this in a mysql query Eclipse tends to hang or return an error about the to_date function.

What is the correct way to accomplish this using mysql?

Thank You.

[Updated on: Wed, 29 June 2011 20:09]

Report message to a moderator

Re: Mysql query to prompt for start and end dates [message #690638 is a reply to message #690602]

Wed, 29 June 2011 21:30

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Have you looked at the STR_TO_DATE function?
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date

Jason

On 6/29/2011 3:59 PM, forums-noreply@eclipse.org wrote:
> Hello. I am new to the forum and realatively new to BIRT as well.
>
> I'm trying to find the equivalent syntax of the following Oracle query
> that prompts for start and end dates when a report is generated.
> where session.created_on > to_date(?, 'YYYY-MM-DD')
> and session.created_on < to_date(?, 'YYYY-MM-DD')
> order by session.created_on asc
>
> When I put this in a mysql query Eclipse tends to hang or return an
> error about the to_date function.
>
> What is the correct way to accomplish this using mysql?
>
> Thank You.

Report message to a moderator

Previous Topic:	Hide the cascading parameter in customized parameter page
Next Topic:	Web Service Data Source - Authentication?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 00:25:26 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter