| time calculation [message #371753] |
Fri, 01 December 2000 16:34  |
kusuma
Messages: 5
Registered: December 2000
Location: India
|
Junior Member |
|
|
I have a table with 5 col.
ID, Login_date, Login_time, Logout_date, Logout_time.
Right now i am storing date and time in different col.
Login_date datatype date
login_time dataType varchar2(8).
How to calculate the difference of logout_time & login_time (subtract(logout_time - login_time)
|
|
|
|
| Re: time calculation [message #371772 is a reply to message #371753] |
Mon, 04 December 2000 09:25  |
Suresh
Messages: 189
Registered: December 1998
|
Senior Member |
|
|
hi,
you dont need to define two columns separately for login_date and login_time..oracle stores date datatype with time stamp..if you insert sysdate in to date column, it inserts time also..
Suresh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
