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)