In Oracle Database, the TO_CHAR(datetime) function converts a datetime or interval value to a VARCHAR2 value in the format specified by the date format.
Tag: date functions
NEW_TIME() Function in Oracle
In Oracle Database, the NEW_TIME() function converts the date from a specified time zone to another specified time zone, and returns the result.
MONTHS_BETWEEN() Function in Oracle
In Oracle Database, the MONTHS_BETWEEN() function returns the number of months between two dates.
LAST_DAY() Function in Oracle
In Oracle Database, the LAST_DAY() function returns the last day of the month that contains the supplied date.
It accepts one argument, which is the date for which you want to find the last day of the month.
Continue readingROUND(date) Function in Oracle
In Oracle, the ROUND(date) function returns a date rounded to a specified date unit.
By default, it rounds the date to the nearest day, but you can provide an optional argument that specifies an alternative unit to use.
Oracle also has a ROUND(number) syntax, which is used on number. This article is solely about the ROUND(date) syntax, which is used on date.
FROM_TZ() Function in Oracle
In Oracle Database, the FROM_TZ() function converts a timestamp value and a time zone to a TIMESTAMP WITH TIME ZONE value.
You pass the timestamp value and the time zone as two separate arguments, and the function returns them as a TIMESTAMP WITH TIME ZONE value.
SESSIONTIMEZONE Function in Oracle
In Oracle Database, the SESSIONTIMEZONE function returns the time zone of the current session.
DBTIMEZONE Function in Oracle
In Oracle Database, the DBTIMEZONE function returns the value of the database time zone.
ADD_MONTHS() Function in Oracle
In Oracle Database, the ADD_MONTHS() function adds a given number of months to a date, and returns the result.
CURRENT_DATE Function in Oracle
In Oracle Database, the CURRENT_DATE function returns the current date in the session time zone, in a value in the Gregorian calendar of data type DATE.