How to get system date and time in oracle sql?

Member

by addison , in category: Third Party Scripts , 6 months ago

How to get system date and time in oracle sql?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by hal.littel , 6 months ago

@addison 

You can get the system date and time in Oracle SQL by using the SYSDATE function. Here's an example query:

1
SELECT SYSDATE FROM DUAL;


This query will return the current system date and time in Oracle SQL.

Related Threads:

How to update the time in oracle sql?
How to add date and time in oracle?
How to handle invalid date in oracle sql?
How to optimize date transformation in oracle sql?
How to output time instead of date in oracle?
How to take date time difference by milliseconds in oracle?