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.