Preamble
Oracle/PLSQL SYSDATE function returns the current system date and time on your local database.
Oracle/PLSQL syntax of the SYSDATE function
SYSDATE
Parameters and function arguments
- No parameters or arguments for the SYSDATE function.
The SYSDATE function returns the date.
The SYSDATE function in the following versions of Oracle/PLSQL
|
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
|
Let’s consider examples of the SYSDATE function and learn how to use the SYSDATE function in Oracle.
SELECT SYSDATE
FROM DUAL;
-Result 01.08.2014 9:36:11
If you want to extract only the date (exclude the time component), you can use the TO_CHAR function.
SELECT TO_CHAR(SYSDATE, 'DD.MM.YYYY').
FROM DUAL;
-Result 01.08.2014
About Enteros
Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
How to Modernize Healthcare Cost Management with Enteros Database Software and Performance Intelligence
- 25 June 2026
- Software Engineering
Introduction Healthcare organizations are undergoing a major digital transformation driven by electronic health records (EHR), telemedicine platforms, AI-powered diagnostics, and cloud-based clinical systems. While these technologies improve patient care and operational efficiency, they also introduce significant financial and infrastructure challenges. Modern healthcare ecosystems now include: Electronic Health Record (EHR) systems Hospital Information Systems (HIS) Laboratory … Continue reading “How to Modernize Healthcare Cost Management with Enteros Database Software and Performance Intelligence”
How to Reduce Healthcare IT Costs with Enteros Database Performance Management and Cost Estimation
Introduction The healthcare industry is under continuous pressure to deliver high-quality patient care while simultaneously reducing operational and IT infrastructure costs. Hospitals, clinics, diagnostic centers, and digital health platforms are rapidly adopting cloud systems, AI-driven diagnostics, and electronic health records (EHR) to improve efficiency and patient outcomes. Modern healthcare ecosystems now rely on: Electronic Health … Continue reading “How to Reduce Healthcare IT Costs with Enteros Database Performance Management and Cost Estimation”
How Real-Time Database Intelligence Prevents Performance Regressions
In today’s digital-first business environment, application performance directly influences customer satisfaction, operational efficiency, and revenue growth. Users expect applications to be fast, reliable, and always available—whether they are completing transactions, accessing dashboards, processing payments, or interacting with enterprise software. Even minor performance slowdowns can negatively impact user experience and business outcomes. One of the most … Continue reading “How Real-Time Database Intelligence Prevents Performance Regressions”
The Role of Database Observability in Accelerating DevOps and CI/CD Pipelines
In today’s fast-paced digital landscape, speed of innovation is a major competitive advantage. Enterprises are under constant pressure to release new features, deploy updates faster, fix issues quickly, and maintain highly reliable digital services. This demand has fueled the widespread adoption of DevOps practices and CI/CD (Continuous Integration and Continuous Delivery) pipelines. DevOps and CI/CD … Continue reading “The Role of Database Observability in Accelerating DevOps and CI/CD Pipelines”