'MT' conversion (OpenInsight 32-Bit) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

{{tag>category:"OpenInsight 32-Bit" author:"Martin Drenovac" author:"Keith Alvey"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== 'MT' conversion (OpenInsight 32-Bit) ====
=== At 13 JUL 2010 06:00:05AM Martin Drenovac wrote: ===
 
 
<QUOTE>
Sorry for what I'm sure is my poor eye-sight.



z	= 74308

zz	= OCONV(z,"MT")      -]]  20:38

zzz    =ICONV(zz,"MT")     -]]  74280



which is causing me some grief as I try to compare records.



What am I not understanding here?

TIA..
</QUOTE>
----

=== At 13 JUL 2010 06:16AM Keith Alvey wrote:  ===

<QUOTE>Hi Martin,



I think because you are using 'MT' it is rounding seconds.

Try using 'MTS' instead.



HTH



Simon

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=829E3D717B0F0B8A8525775F0036F0C8|View this thread on the Works forum...]]