The datetime stamp has been applied, using Mac Absolute time in this case, while the rest of the statements remain untouched.

SELECT

ZVIBERMESSAGE.ZTEXT AS “Message Text”,

datetime(ZVIBERMESSAGE.ZDATE+978307200,'unixepoch','localtime')AS “Message Date”,

ZVIBERMESSAGE.ZSTATE AS “Message Direction/State”

FROM

ZVIBERMESSAGE

*New lines added to the query are bolded.