[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    AW: Date_time_format question ????
From:       "Zabach, Elke" <elke.zabach () sap ! com>
Date:       2004-06-30 8:27:47
Message-ID: 235EE6AC8AE9264CBF763FC6749E27013455C1 () dewdfe22 ! wdf ! sap ! corp
[Download RAW message or body]

A.Beermann@piepenbrock.de 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:a.beermann@piepenbrock.de  |
> > 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/maxdb?unsub=sapdb-general@progressive-comp.com



[prev in list] [next in list] [prev in thread] [next in thread]