How to convert sysdate to utc time in oracle?

Member

by jasen , in category: MySQL , 3 months ago

How to convert sysdate to utc time in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by adan , 3 months ago

@jasen 

You can convert sysdate to UTC time in Oracle by using the following query:

1
2
SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) AS UTC_TIME
FROM DUAL;


This query will extract the current UTC time from the system timestamp and display it as UTC_TIME.