Andre Reitz wrote:
is there an easy way to get the difference of two timestamp fields in
seconds,
independent of the timestamp-Format of the database?
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
easy
way to do
it.
Elke
SAP Labs
Berlin
