Question Nicholas Chimera · Jun 21, 2018

Hello,

I’m running  a query to drive a report.

I have a persistent class that includes this:
Property CreationTime As %TimeStamp [ InitialExpression = {$ZDateTime($ZTimeStamp, 3, 1, 2)} ];

So the above populates the column with UTC time.

Is there a way to convert to local time inside the SQL query?

Thanks!

6
0 4462