OQL datetime string

[Thomas Phan]

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]