[PATCH] Searches like Created = 'YYYY-MM-DD'(was: [rt-users] Query Problem)

[Olivier Horec]

Hi Ruslan,

Thanks for your help

I applied this patch and it solves my problem : it was just a problem
with the GMT+4 timezone.

I applied the pacth "Searches by Owner's fields" about the first
problem and it was successful too !

Thanks again,

Olivier

2005/7/30, Ruslan Zakirov <ruslan.zakirov at gmail.com>:
> Ok, here what we get:
> * I enter '2005-07-30' in search box
> * Time::ParseDate converts it to '2005-07-29 20:00' because of GMT+4 timezone
> * Then constuct search with interval ['2005-07-29 00:00'; '2005-07-29 23:59']
> 
> I think if we play only with dates then we should ignore timezone, so
> I propose attached patch.
> 
> Olivier, could you confirm that patch fixes your problem?
> 
> On 7/28/05, Olivier Horec <olivier.horec at gmail.com> wrote:
> > I had a look at the SQL queries about the date problem.
> >
> > In fact, when I search with a query like : Created = '2005-07-19',
> > I find this in the SQL log :
> > ( ( (main.Created >= '2005-07-18 00:00')AND(main.Created <=
> > '2005-07-18 23:59') ) )
> >
> > Has anyone an idea ?
> >
> > Olivier
> >
> > 2005/7/28, Ruslan Zakirov <ruslan.zakirov at gmail.com>:
> > > On 7/28/05, Olivier Horec <olivier.horec at gmail.com> wrote:
> > > > Hi,
> > > >
> 
> [snip]
> 
> > > > The second problem is when you search tickets with dates : you get the
> > > > tickets one day before the query.
> > > >
> > > > Has anyone tried to solve the problem or can anyone give me some ideas
> > > > to help me to solve it.
> > > >
> > > > Thanks in advance
> > > >
> > > > Olivier
> > > > _______________________________________________
> > > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> > > >
> > > > Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> > > >
> > >
> > >
> > > --
> > > Best regards, Ruslan.
> > >
> >
> 
> 
> --
> Best regards, Ruslan.
> 
> 
>