select p from MyObject p where trunc(modifiedDate) = $1 Regards, Low
-----Original Message----- From: Mutchler, Scott [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 8:13 To: [EMAIL PROTECTED] Subject: [castor-dev] JDO Dates Is there a way to duplicate the Oracle trunc() function in JDO? I have an Oracle date column (with time) that I need to write an OQL statement for. It would look something like this: select p from MyObject p where modifiedDate = $1 I don't care about the time. The trunc() function would allow me to just use the date portion in SQL. Is there an OQL equivalent? If not is there a work-around? Scott Mutchler **************************************************************************** ********************************************************************** "The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential, proprietary, and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all computers." ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
