On Wed, Mar 17, 2010 at 15:45, Thomas Müller <[email protected]> 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 [email protected]
