Eclipse Community Forums: BIRT » Error while query BIRT changes dates

Home » Archived » BIRT » Error while query BIRT changes dates(Help me with this topic, if i execute a query in BIRT it returns with another date)

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

Error while query BIRT changes dates [message #1764703]

Thu, 01 June 2017 13:43

Ulises Guzman

Messages: 2
Registered: June 2017

Junior Member

Hi everyone!
I'm new here but no at BIRT.
But now i've this strange problem.
When i send a query to the database the date returns ok, but when i send the same query with BIRT it returns with minus 2 days.
i attached the examples.

any ideas?

Attachment: BIRT_Pantalla1.png
(Size: 80.09KB, Downloaded 86 times)
Attachment: BIRT_Pantalla2.png
(Size: 64.93KB, Downloaded 87 times)
Attachment: BIRT_Pantalla3.png
(Size: 47.90KB, Downloaded 100 times)

[Updated on: Thu, 01 June 2017 15:30]

Report message to a moderator

Re: Error while query BIRT changes dates [message #1765093 is a reply to message #1764703]

Tue, 06 June 2017 14:04

Ulises Guzman

Messages: 2
Registered: June 2017

Junior Member

This is my query:

select * from erp.LaborDtl
where ClockInDate >= '2017-05-12'
order by ClockInDate

I'd already try to change de - of the date to . (from 2017-05-12 to 2017.05.12)
Also tried with / (2017/05/12)
But i've got the same error.

The curious thing is the information bring by the query correspond to the correct date but the date field shows incorrect.

Report message to a moderator

Previous Topic:	Neon BIRT 4.6 uses old Jetty OSGI Boot 9.2.13.v20150730
Next Topic:	BIRT report designing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 12:35:08 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter