Date_time_format question ????

[A . Beermann]

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 ???

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

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