Eclipse Community Forums: BIRT » data set with field date ?

Home

Home » Archived » BIRT » data set with field date ?

data set with field date ? [message #1789876]

Thu, 31 May 2018 05:13

Eclipse User

i need to execute this request :

select *
from user
where date_creation >=? and date_creation <=?

i created 2 string params
when i execute report, i write this date 2018-03-01 and 2018-03-12
the result is null
but when i modify the request like this :

select *
from user
where date_creation >='2018-03-01' and date_creation <='2018-03-12'

it works
what is the problem ?

Re: data set with field date ? [message #1789991 is a reply to message #1789876]

Fri, 01 June 2018 13:17

Eclipse User

Check the parameter data type.

Re: data set with field date ? [message #1790018 is a reply to message #1789991]

Sun, 03 June 2018 03:23

Eclipse User

thanks for your message
it doesn't work if parameter is string also date type i try it

Re: data set with field date ? [message #1790027 is a reply to message #1790018]

Sun, 03 June 2018 11:27

Eclipse User

Your query "select *
from user
where date_creation >='2018-03-01' and date_creation <='2018-03-12'"
is comparing strings and works by chance of string comparison.

To compare dates you need date types,, e.g.
select *
from user
where to date_creation between to_date('2018-03-01' ,'YYYY-MM-DD') and to_date('2018-03-12','YYYY-MM-DD')

assuming date_creation is a date, not a string.

[Updated on: Sun, 03 June 2018 11:28] by Moderator

Re: data set with field date ? [message #1790042 is a reply to message #1790027]

Mon, 04 June 2018 02:14

Eclipse User

hi,
thank you
it doesn't work
i simplified my exemple just to :

date_creation= str_to_date(?, '%Y-%m-%d')

Re: data set with field date ? [message #1790058 is a reply to message #1790042]

Mon, 04 June 2018 06:13

Eclipse User

i resolved the problem by deleting the table that receives the result then i created the new table with the same data set
the problem is in eclipse it doesn't update and take in consideration the modifications n datasets

Previous Topic:	SEVERE: Cannot process data source extension configuration.
Next Topic:	Passing Maximo where clause

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Mar 15 22:31:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter