Mailing-List: contact dev-help@chemistry.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@chemistry.apache.org
MIME-Version: 1.0
Date: Tue, 12 May 2015 19:18:59 +0200
Message-ID: 
 <CABVM4E6VnjWebhg7XjRxw1HyhCG1OdqHhoF7nCbvaZ8-iE3Mxg@mail.gmail.com>
Subject: Date, not DateTime, queries.
From: Igor Blanco <iblanco@binovo.es>
To: dev@chemistry.apache.org
Content-Type: multipart/alternative; boundary=f46d0444812babc1cd0515e5b031

--f46d0444812babc1cd0515e5b031
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi,

I have an alfresco installation with a custom model with a date property,
date not DateTime. CMIS does not support date, only datetime properties.
Although it is a date property it seems like Alfresco does store it as a
complete datetime and CMIS queries seem to work as you would expect from a
datetime.

So if I want to do queries with a day resolution is there any better way
than converting it to a greater lesser comparison? For examplo if I want to
get documents with today's date is there something cleaner than:

SELECT * FROM my:type WHERE my:date >=3D '2015-05-12 00:00:00.000Z' AND
my:date <=3D'2015-05-12 23:59:59.999Z'

Thanks


--=20
Igor Blanco Gonz=C3=A1lez

--f46d0444812babc1cd0515e5b031--