Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    2

    Unanswered: Calculating time differences in informix

    Hi, I'm new to all this, so bare with me. I have a problem with unix time and "people" time. What I would need to do, is calculate time diffirence between 2 timestamps, so I have starttime and endtime in unixtime, and I need the result to be people time. You guys have any suggestions how to do this ?
    Thanks in advance,
    Keimo

  2. #2
    Join Date
    Apr 2003
    Posts
    2

    More specific about this

    Hi, I would need the result like HH:MINEC .
    Thanks,
    Keimo

  3. #3
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    You might try this:

    select extend(dbinfo("utc_to_datetime", <diff_seconds>), hour to second)
    from systables where 1=1

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •