Suppose I have a table defined as below
CREATE TABLE enquiry (
PRODUCTID int(11) DEFAULT '0' NOT NULL,
CUSTOMERID int(11) DEFAULT '0' NOT NULL,
MADE timestamp(14),
PRIMARY KEY (PRODUCTID,CUSTOMERID)
);
and I need to select records in it based
on the value for MADE, then it seems I
would have to use the addTime method of
a Criteria object as below ...
crit.addTime(EnquiryPeer.MADE,
calendar.get(Calendar.YEAR),
calendar.get(Calendar.MONTH),
calendar.get(Calendar.DATE));
Now, my problem is that all the addTime
methods in Criteria that I can see in the
javadoc only support day granularity.
Perhaps they should be renamed to addDate
and some other methods written for addTime ?
Now if I want to select a record made at a
particular instant (time stamped) how do I
go about it ?
__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
