Thank's a lot Elke, work's great. BTW there is nothing to apologize for. I think it is a big thing having this database for free, whereas you have to spend ten thousands minimum for other comparable databases...
Regards -Alexander- -----Urspr�ngliche Nachricht----- Von: Zabach, Elke [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 10. Januar 2003 13:27 An: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Betreff: RE: DATE PROBLEM in WHERE clause [EMAIL PROTECTED] wrote: > > 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. The last thing was the important in this case. 1. SQLStudio uses ODBC 2. ODBC uses a special date_and_time_format specified by ODBC 3. the kernel knows different date_and_time_formats for internal mode, for Oracle mode (using the date_and_time_format specified by Oracle) and the format needed for ODBC. This together brings much 'pleasure' to the implementation. And in this case it is the reason for a bug which will be fixed with 7.3.0.33/ 7.4.3.11. To make your work possible with SQLStudio: use SQLMODE Oracle and to_date (a, 'dd.mm.yyyy') > '<compare_value>' where <compare_value> IN THIS CASE has to look like an Oracle-date-value, for example: to_date (a, 'dd.mm.yyyy') > '24-DEC-02' (But, please: only use the column-name in the output-list of the select, no TO_DATE(a), that would result in the datetimefield_overflow again) Sorry for any inconveniences Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
