thank you Alexander it works. but ... is there any data type which only includes date and not includes time ?
2010/3/17 Alexander Klimetschek <[email protected]> > On Wed, Mar 17, 2010 at 13:34, JOSE FELIX HERNANDEZ BARRIO > <[email protected]> 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 > [email protected] > -- Jose Hernandez 675599600 Isthari http://www.isthari.com
