users  

Re: Dates in search

JOSE FELIX HERNANDEZ BARRIO
Wed, 17 Mar 2010 07:49:26 -0700

i've tryed:

select * from temp where( date_ >=cast ('2010-02-01' as date))

and it results on InvalidQueryException


2010/3/17 Thomas Müller <thomas.muel...@day.com>

> Hi,
>
> > but ... is there any data type which only includes date and not includes
> > time ?
>
> Yes: DATE.
> cast(... as date)
>
> Regards,
> Thomas
>



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