Feb 29, 2016 · This tutorial provides you with the most commonly used Oracle date functions that help you handle date and time data easily and more effectively.

Dec 31, 1999 · This tutorial shows you how to use the Oracle EXTRACT () function to extract a value of a specified field of a date time value.

May 5, 2025 · Summary: In this tutorial, you’ll learn how to use the Oracle TO_DATE() function to convert a date string to a value of the DATE type using a specific format.

This tutorial introduces you to the Oracle DATE data type and shows how to handle date and time date effectively.

This tutorial shows you how to use Oracle TRUNC () function to truncate a date to a specified unit and gives you some practical examples.

This tutorial shows you how to use the Oracle CURRENT_DATE function to get the current date and time in the session time zone.

Dec 31, 1999 · This tutorial shows you how to use the Oracle Date Format for formatting date values.

This tutorial shows you how to use the Oracle TO_CHAR () function to convert a date or number to a string in a specified format.

How to develop a PL/SQL function and call it in various places such as an assignment statement and an SQL statement.

This tutorial shows you how to use the Oracle ROUND () function to get a date value rounded to a specific unit e.g., YEAR, MONTH, DAY, etc.