AnsweredAssumed Answered

Strange Timezone issue in date query

Question asked by geert on Sep 14, 2011
Hi,

When I query the Alfresco Repository using the following query (correct timezone GMT+2):

SELECT park:readDate
FROM park:document
WHERE park:readDate > TIMESTAMP '2011-09-13T00:01:29.960+02:00'

I have no results. When I adjust the query timezone to:

SELECT park:readDate
FROM park:document
WHERE park:readDate > TIMESTAMP '2011-09-13T00:01:29.960+03:00'

I have one result:

2011-09-13 10:53:11 +0200

Shouldn't the result show up in both queries?

Kind regards,

Geert

Outcomes