oracle8.1.6 select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual select to_char(timezone.local_to_utc(timezone.get_id(:system_timezone), sysdate), 'YYYY-MM-DD HH24:MI:SS') from dual