Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2015

    Unanswered: Re: "COLISSIMO LIVRE" mais pas reçu!

    I have a problem with one field that is stored in UTC time format. Basically, the problem is that this particular field, completionTime, stores a time stamp in UTC when the end users accomplish a particular task. Those who have tasked me with my work have asked me to pull the length of time since the task was done. so this should be a simple matter of subtracting sysdate -
    Last edited by Pat Phelan; 05-14-15 at 09:28.

  2. #2
    Join Date
    Sep 2011
    Pont l'Abbé, Brittany, France
    Provided Answers: 1
    did you check the dbinfo / utc_to_datetime stored procedure?
    it converts a UTC value into a datetime. Is this what you want?

Posting Permissions

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