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

Help

Home

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

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

data set with field date ? [message #1789876]

Thu, 31 May 2018 09:13

mim Awnaf

Messages: 6
Registered: May 2018

Junior Member

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 ?

Report message to a moderator

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

Fri, 01 June 2018 17:17

Eric Davis

Messages: 17
Registered: March 2018

Junior Member

Check the parameter data type.

Report message to a moderator

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

Sun, 03 June 2018 07:23

mim Awnaf

Messages: 6
Registered: May 2018

Junior Member

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

Report message to a moderator

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

Sun, 03 June 2018 15:27

Colin Sutton

Messages: 121
Registered: July 2009

Senior Member

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 15:28]

Report message to a moderator

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

Mon, 04 June 2018 06:14

mim Awnaf

Messages: 6
Registered: May 2018

Junior Member

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

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

Report message to a moderator

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

Mon, 04 June 2018 10:13

mim Awnaf

Messages: 6
Registered: May 2018

Junior Member

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 08:11:47 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter