This seems to work

SELECT
    TableName,
    CAST(DATEDIFF(second, '1970-01-01', 
        LastUpdateDate AT TIME ZONE 'my time zone' AT TIME ZONE 'UTC') AS BIGINT) AS TimestampInSeconds
FROM
    SynchronizationVersions r
WHERE
    LastUpdateDate IS NOT NULL;