Oracle comparing dates : dates, oracle, date comparison in oracle pl/sql

How to compare dates in oracle?There are a number of ways you can compare two dates in oracle to check which is greater or which is small.This is particularly useful when we do operations based on certain date conditions.This is used along with to_date and other date functions.

ORA-01882: TIMEZONE REGION NOT FOUND |Oracle Error

ORA-01882: TIMEZONE REGION NOT FOUND. This error occurs when timezone region string not found.The specified region name was not found.There are a number of time zone constants defined in oracle to use.See the last part of this post to know hoe to get the defined time zone constants in your oracle database.

Oracle Dates and Times |SYSDATE|CURRENT_TIMESTAMP |SYSTIMESTAMP |DBTIMEZONE |LOCALTIMESTAMP

The DATE type is stored in a special internal format that includes not just the month, day, and year, but also the hour, minute, and second.There are a number of key words and functions provided by oracle to use the date and timestamp data types in much flexible ways.