Re: Dates in search

[JOSE FELIX HERNANDEZ BARRIO]

thank you Alexander it works.

but ... is there any data type which only includes date and not includes
time ?





2010/3/17 Alexander Klimetschek <aklim...@day.com>

> On Wed, Mar 17, 2010 at 13:34, JOSE FELIX HERNANDEZ BARRIO
> <jose.hernan...@isthari.com> wrote:
> > I'm trying to search between two dates:
> > select * from temp where( date>='2010-02-01' and date<='2010-02-11')
> > but the result is wrong
>
> You need to use sql's TIMESTAMP:
>
> select * from temp where( date >= TIMESTAMP '2010-02-01T00:00:00.000Z'
> and date >= TIMESTAMP '2010-02-11T00:00:00.000Z')
>
> (Note: the string literal must be a full ISO 8601 string, including
> milliseconds and timezone offset part.)
>
> Regards,
> Alex
>
> --
> Alexander Klimetschek
> alexander.klimetsc...@day.com
>



-- 
Jose Hernandez
675599600
Isthari
http://www.isthari.com