Problem with date/time. How-to : 1

[FORAND]

hi

I have 2 sets of data :
Time of entry
Time of exit

Both data are varchar2(17), both data are something like this :
05/10/07 08:01:49
05/10/07 08:02:58

How can I find the time elapsed between "entry" and "exit"?

Thanks in advance

Forand

 

[Dagon]

It depends what you want to measure the difference in but, assuming it's seconds, you would use:

select (to_date('05/10/07 08:02:58','DD/MM/YY HH24:MI:SS') - to_date('05/10/07 08:01:49', 'DD/MM/YY HH24:MI:SS')) * 86400
from dual

 

[FORAND]

Thanks! That is exactly what I was looking for.
Star for you!