Use between date in where clause

Submitted by:Jhon Jhon

Date added:20 February, 2012

Category:SQL

SQL select query with between date to show records in where clause

Tags: search by date

Code Snippet:

SELECT * FROM emp_table
WHERE hiredate >= to_date('2005/01/01', 'yyyy/mm/dd')
AND hiredate <= to_date('2010/12/31','yyyy/mm/dd');
 
 

Comments