Hi everyone, I am actually evaluating SAP DB for commercial use having a DATE problem in where clauses on selects. Having a string column containing dates of the format dd.mm.yyyy how can I do a query like ... WHERE TO_DATE(TEST_DATE, 'dd.mm.yyyy') > ...
Using SQL Studio testing several approaches (e.g. DATE(...) I am getting either an Invalid Date Format or unknown function or an Datetime overflow error). In oracle mode I am getting a datetime overflow in an odbc dll). Any helps appreciated -Alexander- -------------------------------------------------------------------- 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
