Problem with date/time

[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

 

[r937]

perhaps you could re-post this question in the forum for your particular dbms (oracle?)

you aren't going to like the ANSI SQL answer



r937.com | rudy.ca

 

[SQLSister]

And I'd let this be a lesson in why it is a bad idea to store dates in a character datatype instead of a date datatype.

"NOTHING is more important in a database than integrity." ESquared