CURRENT_TIMESTAMP function in Oracle

By Santhosh N

This explains how to get the current date and time along with the time zone that is set for the session.

There is function by the name, CURRENT_TIMESTAMP for fetching the current date and time along with the time zone that is set to the current session.

Syntax: CURRENT_TIMESTAMP

ex: SELECT CURRENT_TIMESTAMP from DUAL;

Note: The value returned will be changed based on the alter session command issued for the session and also varies the time zone if specified as part of the alter session command.

Related FAQs

What is the real purpose of dual in oracle.
There are four types of Datatypes for date in oracle including the support to the time and timezone info alongwith daylightsavings time where applicable
This explains how to add the number of months to a given date in oracle
This explains how to get the current date along with the time that is set for the session.
Oracle provides a seperate datetype for storing time zone information in the column
This explains how to get the last day of the month from the specified date in oracle
CURRENT_TIMESTAMP function in Oracle  (1685 Views)