Heiko Giesselmann wrote: > Hi, > > I have an application that works in Oracle mode. There is a table with a > timestamp field and I am looking for a way to add an integer > representing seconds to that timestamp field with a value of type > timestamp as a result. The following is a working expression in Internal > mode: > ADDTIME(timestamp_field, MAKETIME(0,0,integer_field)) > Unfortunately, this obviously doesn't work in Oracle mode due to the > MaxDB specific functions and the syntax that works in an native Oracle > database (simply 'timestamp_field + integer_field') doesn't work either. > > Anybody any ideas how to solve this other than switching to internal > mode for a single statement? > What about: - using version 7.5.01 - creating a function (with the timestamp-field and the integer as parameter) in sqlmode internal using that ADDTIME(timestamp_field, MAKETIME(0,0,integer_field)) mentioned before - calling that function (even in Oracle-mode)
Elke SAP Labs Berlin > Thanks, Heiko > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
