its one of the silliest things I've ever seen, but...
# generalb
battk
09/11/2019, 1:55 AMits one of the silliest things I've ever seen, but
SYS_EXTRACT_UTC(TO_TIMESTAMP_TZ(TO_CHAR({datecreated},'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS'))