Oracle SYSDATE function
Description
The SYSDATE function is used to get the current date and time set for the operating system on which the database resides.
Syntax:
SYSDATE
Parameters:
The function requires no parameters.
Applies to:
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i
Return Value:
This function returns the date and time set for the operating system of your local database.
Pictorial Presentation

Examples: Oracle SYSDATE function
The following statement returns the current operating system date and time :
SQL> SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW"
2 FROM DUAL;
Sample Output:
NOW ------------------- 05-01-2015 15:39:45
Previous:
SYS_EXTRACT_UTC
Next:
SYSTIMESTAMP
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join