interval calculation

[Jan Schneider]

Does anybody know an efficient, compatible way to calculate time intervals in 
sql? Plus and mines operators with INTERVAL is not supported by all databases 
as probably are not functions like mysql's date_add().

Jan.

:::::::::::::::::::::::::::::::::::::::: 
AMMMa AG - discover your knowledge
:::::::::::::::::::::::::::
Detmolder Str. 25-33 :: D-33604 Bielefeld
fon +49.521.96878-0 :: fax  +49.521.96878-20
http://www.ammma.de
::::::::::::::::::::::::::::::::::::::::::::::