Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: local policy)
From: "davy" <davypulinckx@telenet.be>
To: user-java@ibatis.apache.org
Importance: Normal
Sensitivity: Normal
Message-ID: <W805625217234381186581701@nocme1bl6.telenet-ops.be>
Date: Wed, 08 Aug 2007 14:01:41 +0000
Subject: Small problem with date.
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

I have the next problem, I have a query which must filters a certain period out a number. for example:
this is the number 54789635479E200708081545 this means 
2007 year 08 month 08 day 15 hour 45 minutes.
Now, i have a query (substr(number,13,8) between ? and ? 

This means that the user can give a certain from date and until date (year,month,day) sow the query will search on this date in these number

I have developed this :

Example.setOrderByClause("substr(number,13,8)");
Example.createCriteria().andnumberBetween(fDate, uDate);

fDate and uDate = are both strings, these are the 2 dates that the user has given to search for. 
for example 
fDate = 20050101 from 
uDate = 20063112 until

When i use the query, al my numbers are displayd, butt the query have not worked properly.
Is there someone that has a proposal how it must be done.