How do I compare dates with SQL Oracle

Comparison Method

Compare dates stored in an Oracle database using the standard comparison operators including "=", "!=", ">" and ":<" within the structured query language (SQL) statement. The following statement returns all data for rows in the "date_table" where "date1" is an earlier value than the "date2" value.



select * from date_table where date1 < date2