current_date function in oracle

By Santhosh N

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

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

Syntax: CURRENT_DATE  

ex: SELECT CURRENT_DATE  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

This explains how to get the last day of the month from the specified date in oracle
This explains how to find the number of months between two dates in oracle
This explains how to add the number of months to a given date in oracle
Oracle provides a seperate datetype for storing time zone information in the column
There are four types of Datatypes for date in oracle including the support to the time and timezone info alongwith daylightsavings time where applicable
There is a table in oracle with the name V$TIMEZONE_NAMES where the timezone abbreviations and timezone names are availble
current_date function in oracle  (1751 Views)