Hi everyone,
I am currently evaluating SAP DB for commercial use and having a problem
specifying a date where expression. Here's my problem.
The column is a STRING column called TEST_DATE containing values
in the format DD.MM.YYYY.
All I want to do saying something like
WHERE TO_DATE('DD.MM.YYYY') > TO_DATE(05.04.2002').
I tried moving to the DATE() function or using another
date format, but I am always getting an error
like Datetime field overflow or invalid function.
Any ideas appreciated
-Alexander-
BTW: I am using SQL Studio an tried the internal as well as the oracle
mode.
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
