O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Handling DATE functions

Handling values with the DATE datatype in SQL presents several challenges. In Oracle and many other database systems, this is primarily because a date is neither a string value nor a numeric value. Yet, using the proper functions, we can transform values of the DATE datatype into string values and even do date arithmetic. To see how this works, let's begin by returning to the subject of SYSDATE that we mentioned in Chapter 2, SQL SELECT Statments.

Distinguishing SYSDATE and CURRENT_TIMESTAMP

As we mentioned in Chapter 2, SQL SELECT Statments, SYSDATE is an Oracle pseudo-column—it does not represent an actual column value, but rather returns a system value generated by Oracle. In the case of SYSDATE, it returns the current ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required