[EMAIL PROTECTED] wrote: > > Hello everybody !! > > In my database (maxdb 7.5) Date_time_format is set to "eur" > > In my application the date format = german (dd-mm-yyyy) > > I can do: > mydate = date() = 30.06.2004 > > update tablexyz set d_date = '?mydate' where ...... > insert into tablexyz (d_date) values(?mydate) > everything ok ! > > > I can not search for special dates ???
You can do, but see below > > select * from tablexyz where d_date <= ?mydate > > Connectivity-Fehler: [MySQL MaxDB][SQLOD32 DLL][MaxDB] Datetime field > overflow;-3048 POS(58) Invalid date format:ISO > [MySQL MaxDB][SQLOD32 DLL][MaxDB] Datetime field overflow;-3048 POS(58) > Invalid date format:ISO > 22008 > -3048 This is not done in your application, but with SQLStudio, isn't it? SQLStudio uses ODBC, ODBC has its own date-and-time-format overwriting the setting in the database. Therefore with ODBC/JDBC/SqlStudio/... the ODBC-date-and-time-format has to be used which looks like the ISO format described in the manual. Elke SAP Labs Berlin > Any help welcomed > > Best regards > > Albert > > ''''' > ''''''''' > (0 0) > +---------oOO-------(_)-------------------+ > | Tel: 0541/5841-868 | > | Fax: 0541/5841-869 | > | Mail: mailto:[EMAIL PROTECTED] | > | Internet: http://www.piepenbrock.de | > +-------------------------------oOO-------+ > |__|__| > || || > ooO Ooo > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
