PHP General PHP Frameworks PHP Databases PHP Security Third Party Scripts PHP CMS Javascript MySQL HTML & CSS

Third Party Scripts

How to convert sysdate to utc time in oracle?

Member

jasen

by jasen , in category: MySQL , 6 months ago

How to convert sysdate to utc time in oracle?

12

1 answer

Member

adan

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

0

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?