Sorry for being the one millionth guy, who asked for DATE Values ...
But there is a (I hope tiny) problem with Date comparison :
I have two Values, a Timestamp-Value in the sapdb database (table001.col_date), like
19990123143008456234
and a Date Value, with which I want to compare :
05/06/2003
(is's the best way for me, to retain that DATE Format )
Now, I want make a selection like :
SELECT * FROM table001 WHERE col_date <= CHAR (TIMESTAMP ('05/06/2003') , ISO)
but this doesn't work. (always the error : Invalid date format:ISO. )
Because this SELECT runs over jdbc , the search-date(right side of search- condition) must be in ISO-Format, so that I could compare it with the TIMESTAMP Values in Table001. How could I do that ?
Best regards, Danny
-- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
