Re: OQL datetime string

Mon, 17 Mar 2003 09:08:25 -0800

hi thomas,

what happens when you use the standard jdbc escape for date ?

jakob

Thomas Phan wrote:

Hi,

Is there an escaped string format for datetime in OQL that allows all JDBC
drivers to:

odmg.newOQLQuery().create("select user from " + Users.class.getName() + "
where modifiedOn<='2003-03-17'"); <- I'm not sure about the
"modifiedOn<='2003-03-17'" part

In JDBC, we can "select * from Users where modifiedOn<={d '2003-03-17'}"


FYI,

CREATE TABLE Users(
   userId          VARCHAR2(50)     NOT NULL,
...
   createdBy       VARCHAR2(50),
   createdOn       DATE,
   modifiedBy      VARCHAR2(50),
   modifiedOn      DATE,
   CONSTRAINT PK_Users PRIMARY KEY (userId)
);

Thanks

Thomas


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]






---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to