Specify date in where clause

Submitted by:Jhon Jhon

Date added:20 February, 2012

Category:SQL

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

Tags: search by date

Code Snippet:

SELECT * FROM Emp_Table WHERE to_char(Start_Date,'DD-Mon-YY') ='06-JAN-01';
 
 

Comments