display time as clock
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: display time as clock

  1. #1
    Join Date
    Nov 2000
    Posts
    198
    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]

  2. #2
    Join Date
    Nov 2000
    Posts
    198
    is it even possible to do that ????
    I am using forms6i

    Thanks in advance...

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Nov 2000
    Posts
    198
    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

  5. #5
    Join Date
    Apr 2002
    Posts
    6
    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
  •  



Click Here to Expand Forum to Full Width