Ask Question Sign In Sign Up

How to convert sysdate to utc time in oracle?

Member

by jasen , in category: MySQL , 10 months ago

How to convert sysdate to utc time in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by adan , 10 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 time interval in oracle to number of days in oracle?
How to convert varchar2 to time in oracle?
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 get previous working date using trunc(sysdate) in oracle?

This site uses cookies to ensure you get the best experience. By clicking "Got it" or continuing to browse the website, you are agreeing to our use of cookies. See our Privacy Policy.