Home » SQL & PL/SQL » SQL & PL/SQL » pls help me
pls help me [message #217910] Tue, 06 February 2007 01:28 Go to next message
yaktnkl
Messages: 1
Registered: February 2007
Location: india
Junior Member

hi,
how can i get time span between 2 times using oracle.
just like, i went to the office at 09:45:34 and leave from office
at 19:15:11 .now i want, how much time i spent in my office.
i want sql query
Re: pls help me [message #217912 is a reply to message #217910] Tue, 06 February 2007 01:29 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
What have you tried so far?
Re: pls help me [message #217952 is a reply to message #217912] Tue, 06 February 2007 03:32 Go to previous message
ruyue
Messages: 9
Registered: July 2006
Junior Member
You just can use date1-date2 to complete it.
Previous Topic: pls_integer
Next Topic: PL/SQL mail problem
Goto Forum:
  


Current Time: Thu Dec 08 04:02:17 CST 2016

Total time taken to generate the page: 0.06653 seconds