| related about calculating time? help me [message #85994] |
Thu, 19 August 2004 16:32  |
Dhalan
Messages: 15
Registered: August 2004
|
Junior Member |
|
|
ICNO 00-288572 00-288573
start_am 14:08:16 14:08:20
end_am
select to_char(sysdate, 'hh24:mm:ss') into :test.start_am ---[>] i use this statement for time at start_am
hai,
for example, after user 1 enter his ic no 00-288572 the time will automatically put at start_am and then he save it. after that 2nd user enter his ic no 00-288573 and it also generate automatically as u can see from above example.
for example if user 1 want to go out for lunch he must enter his ICNO once again.
my question is, if user 1 enter his ICNO once again, i want to display the Start_am(14:08:16) and the new time at end_am so that i can calculate the difference between start_am and end_am
thank you
regards
eboy
|
|
|
|
| Re: related about calculating time? help me [message #86052 is a reply to message #85994] |
Wed, 25 August 2004 13:54  |
Moi
Messages: 15
Registered: August 2004
|
Junior Member |
|
|
I am unsure of the problem:
your example is OK:
select to_char(sysdate, 'hh24:mm:ss') into :test.start_am
and likewise
select to_char(sysdate, 'hh24:mm:ss') into :test.end_am
would be fine.
leaving you to check whether :test.end_am is not NULL prior to update.
"Only guessing that this is what you mean."
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
