Let's take an overview of the Oracle data types and see how to compare dates using the TO_DATE() function, the TRUNC() function, or a date/timestamp literal. The article also describes how to change the date format using the ALTER SESSION statement - https://www.devart.com/dbforge/oracle/studio/comparing-dates-oracle.html
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
If you enjoyed what you read here, create your account today and start earning FREE STEEM!