Two Methods for Oracle Database date range search

OracleDatabaseDate range searchThe two methods are the main content we will introduce in this article. Next we will introduce them through an actual example, hoping to help you.

For example, to search records with dates less than-1-5, use the following method:

Method 1: Convert to date and then compare)

 
 


  
  
Select *

  
  
From mytable

  
  
Where mydate <to_date ('2017-1-5 ', 'yyyy-mm-dd ')

 
 

Method 2: convert to a string and then compare)

 
 


  
  
Select *

  
  
From mytable

  
  
Where to_char (mydate, 'yyyy-mm-dd') <'2017-1-5'

 
 

The above are two methods for searching the date range of the Oracle database. We will introduce them here. If you want to know