[EMAIL PROTECTED] wrote: > Hello one more time, > > we have resolved our first problems with dates after > migration from Oracle. > Now we have SQL the use the Oracle function > nvl(field,'nothing') to set the > second parameter to field if it is null. > > Example: select a ,NVL(b, 'nothing') as B from testdb5 > If we use this sentence in SQL Studio (Oracle Mode) we get "General > error;-3065 POS(19) Invalid date input value."
So, your column field is a column of datatype DATE, isn't it? --> use a value of datatype DATE instead of 'nothing' or use NVL (TO_CHAR(field), 'nothing) Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
