Oracle Datetime | Date & Time Function - oracle tutorial - sql tutorial




What is Oracle Date Time Function ?

  • The Oracle/PLSQL CURRENT_DATE and CURRENT_TIMESTAMP function Returns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command.

Syntax:

CURRENT_DATE
click below button to copy the code. By - oracle tutorial - team

Example:

 oracle date functions time zone
  • Alter Session Set TIME_ZONE is used to set your time zone value for identifying your actual time.

Example:

 oracle date query functions
  • Current_Date from dual statement Returns the current date.

Time Function:

  • The Oracle/PLSQL CURRENT_TIMESTAMP function returns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command. It returns a TIMESTAMP WITH TIME ZONE value.
  • Similarly we can find the current time using CURRENT_TIMESTAMP keyword.
 oracle date functions time
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

Other Date and Time Function:

  • ADD_MONTHS - Returns a date with a specified number of months added.
  • LOCALTIMESTAMP - Returns the current date and time in the time zone
  • SESSIONTIMEZONE - Returns the current session's time zone as a time zone offset
  • MONTHS_BETWEEN - Returns the number of months between date1 and date2.
  • SYSDATE - Returns the current system date and time on your local database.
  • NEW_TIME - Converts a date from time zone1 to a date in time zone2.
  • NEXT_DAY - Returns the first weekday that is greater than a date
  • TRUNC(dates) - Returns a date truncated to a specific unit of measure.

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning

Related Searches to Oracle Datetime | Date & Time Function