select UNIX_TIMESTAMP(timestamp_field) as timestamp_field ...

execute query put timestamp_field into $timestamp_field

print scalar(localtime($timestamp_field))