Re: How to compute difference between two timestamps?

Hi Klaus,

> Now I want to compute the difference between two of these timestamps.

select to_date('31.12.2000 00:00:00', 'dd.mm.yyyy hh24:mi:ss') - sysdate from dual;

I think this is a RTFM issue.

> Another question is: what is going on, if there is a switch to daylight
> savings time, does oracle recognize this?

To my knowledge: no.

regards,

Toni

-- 
Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner