Date FUNCTIONS in SQL- Single Row Functions
➢ Sysdate
➢ Current_date
➢ Current_timestamp
➢ Systimestamp
➢ Localtimestamp
➢ Dbtimezone
➢ Sessiontimezone
➢ To_char
➢ To_date
➢ Add_months
➢ Months_between
➢ Next_day
➢ Last_day
➢ Extract
➢ Greatest
➢ Least
➢ Round
➢ Trunc
➢ New_time
➢ Coalesce
Oracle default date format is DD-MON-YY.
We can change the default format to our desired format by using the following command.