Ask Question Sign In Sign Up

How to convert sysdate to utc time in oracle?

Member

by jasen , in category: MySQL , 2 months ago

How to convert sysdate to utc time in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by adan , 2 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.

Related Threads:

How to convert from utc to another timezone using moment?
How to convert unix timestamp to utc 0 format in mysql?
How to convert new date() to utc date using moment.js?
How to convert the moment.js time to local time?
How to convert timestamp to yyyy-mm-dd hh24:mi:ss format in oracle?
How to convert time format in codeigniter?