display time as clock

Hi,
1) How can I display the date with time on my forms
as a CLOCK

2) how can I display the diff between 2 dates as
mm-dd-yy hh:mm:ss.

both dates are of DATE datatype and they are populated with
DATETIME.

Thanks

[Edited by ocpdude on 07-18-2002 at 09:09 AM]

is it even possible to do that ????
I am using forms6i

Thanks in advance...

Quote:

---

Originally posted by ocpdude

2) how can I display the diff between 2 dates as
mm-dd-yy hh:mm:ss.
[Edited by ocpdude on 07-18-2002 at 09:09 AM]

---

Difference of dates is expressed in number of days.

Hi,

TIMEIN----------------TIMEOUT
------------------------------------
19-jul-02 11:14:00-- 19-jul-02 11:16:25

I am trying to get the HOURS:SECONDS (HH:SS) from the diff between timeOut - timeIn..

I've tried to use this query:

select floor((timeout- timein)*1440)||':'||(timeout - timein)* 86400 from table. I got 2:145 as an answer wich is off by
10 seconds

any idea on how can I get the exact difference ?

Thanks

Your function and result look right to me.

11:16:25 - 11:14:00

should be 0 hours 2 minutes and 25 seconds = 145 seconds.

The 2: is the only part that looked wrong to me.