Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@jackrabbit.apache.org
Received-SPF: pass (athena.apache.org: domain of jukka.zitting@gmail.com
 designates 209.85.198.226 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=kYAarNjT5SwlAg7BPql+vqupk/iSwsXitl/K1A94xYBp8vOy3lEn3Cu0Am5vXcYYZ+
         Z5BVvSOqogCt7myFnmlunMJX4rxGeDStWz7pJ0gkkEI4+6EvrOTEHG32MewO/lgKtQWx
         MaNghPkBBEZ8oGNSApC/gkxcXNeLJIuqAg0U0=
Message-ID: <510143ac0811130509x279cb5c8re61adb89b4ee5696@mail.gmail.com>
Date: Thu, 13 Nov 2008 14:09:12 +0100
From: "Jukka Zitting" <jukka.zitting@gmail.com>
To: dev@jackrabbit.apache.org
Subject: Re: Comparing by time
In-Reply-To: <20472546.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <20472546.post@talk.nabble.com>

Hi,

On Thu, Nov 13, 2008 at 1:22 AM, pkrishna <prabhakar.krishnaswami@ge.com> wrote:
> I am trying to do a search based on Modified time. What I am observing is the
> time format in the node is different from when I am using a
> SimpleDateFormat; For example, in the node the lastModified time is saved as
> 2008-11-12T16:46:57.089-07:00. I used SimpleDateFormat using the pattern
> yyyy-MM-dd'T'HH:mm:ss.SSSZ which seems to be the closest to the format of
> the time in the node. I observed for the same date, the call
> SimpleDateFormat.format produces a string which ends with -700 which is
> slightly different from -07:00. So my question is how I incorporate into a
> query that does an exact match on the date. Is this even possible?

The easiest way to format dates using the exact format specified in
JSR-170 is to use the following code:

    Calendar date = ...;
    session.getValueFactory().getValue(date).getString();

Similarly, you can parse JSR-170 date values like this:

    String date = ...;
    session.getValueFactory().getValue(date).getDate();

BR,

Jukka Zitting