Andre Reitz wrote:is there an easy way to get the difference of two timestamp fields in seconds,Thank you very much, but this doesnt resolve the problem.
independent of the timestamp-Format of the database?
If you can assure that those two timestamp fields do not differ more than 1 day:select (hours(mydiff)*3600 + minutes(mydiff)*60 + seconds(mydiff) from (select timediff (one_timestamp, the_other_timestamp) mydiff from tab)that is not easy, but possible.If you cannot assure the small difference between those values, there is no easyway to do it.ElkeSAP Labs Berlin
what about
SELECT NUM(Date1)-NUM(Date2) ?
Will this query succeed when an other TIMEStamp-Format ist set in the
INSTANCE?
Greetings, Andre'
-- _____________________________________________ inworks GmbH Andre Reitz Magirusstrasse 44 Tel. 0731/93 80 7-21 89077 Ulm http://www.inworks.de
