jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Klimetschek <aklim...@day.com>
Subject Re: Dates in search
Date Wed, 17 Mar 2010 18:39:45 GMT
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

Mime
View raw message