2 Replies Latest reply: Jul 4, 2012 5:31 PM by Stefan Wühl RSS

    Milliseconds in timestamps

    Juan Lopez

      Hi everyone,

       

      so, recently I found an information system that records the timestamps down to the millisecond resolution, so i was wondering how on earth would i show this on QV, because clearly the fractional value is being taken into account like this:

       

      =if(Date(41234.999999, 'hh:mm:ss') = Date(41234.99999, 'hh:mm:ss'), 1, 0)

       

       

      now.... both these dates throw out:    23:59:59

       

       

      BUT, the if expression evaluates to 0... which means that they are not equal

       

       

      so,,, 2 questions:

       

      how should I format the times for the milliseconds to show, or how to increase the time resolution for this matters.....

       

      and,,, for the comparison (and possible association of this field...) how should I reformat this date for it to be associated ??

       

      thanks for your time

       

      EDIT:   on second thought, the way QV is making the associations is good, and maybe is just a matter of consolidating the databases' time format in a per case basis. im marking swuehl 's answer as helpful in the meantime as to let anyone with another idea to see the question....

        • Re: Milliseconds in timestamps
          Juan Lopez

          ok,,, for the comparison part....

           

          i found a workaround....

           

           

          =if(Date#(Date(41234.999999, 'hh:mm:ss')) = Date#(Date(41234.99999, 'hh:mm:ss')), 1, 0)

           

          evaluates to 1,,, which means those are equal... at least for the association, that works,,,, but that does not leave me completly satisfied due to the modification of the data......  

           

          what would happen if millisenconds were REALLY important to my client??? grrrr....

           

          c' ya