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

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×