Convert UTC to local time via SQL

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!