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?
Thanks, Heiko
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
