On Wed, Mar 17, 2010 at 15:45, Thomas Müller <thomas.mueller@day.com> wrote:
> Hi,
>
>> but ... is there any data type which only includes date and not includes
>> time ?
>
> Yes: DATE.
> cast(... as date)

I believe JCR SQL only supports TIMESTAMP. Since JCR Date properties
have a timestamp included, there is no need for a separate date
property. I recommend storing pure dates with 0:00 time in the UTC (Z
in iso8601) timezone in JCR.

Regards,
Alex

-- 
Alexander Klimetschek
alexander.klimetschek@day.com