-
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...
-
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.
Jeff Hunter
-
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.
Corey Horton
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|