$ZDATETIME($HOROLOG,3) - 3 hours

Question

Question

Michael Wood · 23 hr ago

Anyone know how to subtract three hours from $ZDATETIME($HOROLOG,3)?

If $ZDATETIME($HOROLOG,3) returns 2025-01-30 10:17:04, I would like $ZDATETIME($HOROLOG,3) - 3 hours to return 2025-01-30 07:17:04

Product version: IRIS 2023.1

Discussion (4)1

Log in or sign up to continue

Matjaz Murko · 22 hr ago

Hi.

Try:
$SYSTEM.SQL.Functions.DATEADD("HH",-3,$H)

1 0

Robert Cemper · 9 hr ago

this fails with <ILLEGAL VALUE> if time part is negative (before 3AM)

0 0

score 0 · Answer 1 · 2025-01-31T03:42:25-05:00

Ian Pears · 10 hr ago

you could try

w $ZDATETIME(+$H_","_($p($h,",",2)-10800),3)

there will be many ways.

0 0

score 0 · Answer 2 · 2025-01-31T10:27:10-05:00

Ian Pears · 3 hr ago

so it would - thanks Robert

0 0