Wrong data conversion when returning ZTIMEH and ZTIME

Question

Question

I encountered an unexpected behavior while working with the $ZTIMEH and $ZTIME functions, specifically with times between 12:00 and 13:00. Here's what I observed:

W $ZTIMEH("08:50:38.975411826")
Output: 31838

W $ZTIME(31838,1)
Output: 08:50:38

This behavior is correct as $ZTIME returns the expected time of 08:50:38.

However, with the following example:

W $ZTIMEH("12:05:38.975411826")
Output: 338

W $ZTIME(338,1)
Output: 00:05:38

This seems incorrect to me. $ZTIME should have returned 12:05:38, but instead it returns 00:05:38.

Based on our findings, this appears to only occur at times between 12pm and 1pm (12h/13h).

Has anyone else had this problem or found a workaround?

Product version: IRIS 2022.1

Discussion (2)1

Log in or sign up to continue

score 0 · Answer 1 · 2024-09-03T08:49:01-04:00

From docs:

tformat = 1 >>> Express time in the form "hh:mm:ss" (24-hour clock).

W $ZTIME(338,1,)
00:05:38

W $ZTIME(338+43200,1)
12:05:38

My guess: You look for this

W $tr($ZTIME(338,3),"AM")
12:05:38

score 0 · Answer 2 · 2024-09-03T14:22:20-04:00

This is the part that's not behaving as expected:

W $ZTIMEH("12:05:38.975411826")
Output: 338

On my instance I get Output: 43538.975411826

$ZTH takes a 2nd argument that specifies the time format. If you omit that value it uses the default, which you can see with this:

WRITE ##class(%SYS.NLS.Format).GetFormatItem("TimeFormat")

I suspect you'll get 3 or 4, since those are the formats for 12 hour clock.

Try sending 1 or 2 for 24 hour clock:

W $ZTIMEH("12:05:38.975411826", 1)

https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=RCO...