I have table that contain employee info now i want to display Employee info who have joined before 2000-2-5
What Query should i Write
I have written Select * From Empinfo where Dataofjoining> 2000-2-5
But it's displaying the all the employee beore 2000-2-5.
Please help me.
I have written Select * From Empinfo where Dataofjoining> 2000-2-5
But it's displaying the all the employee beore 2000-2-5.
Please help me.
VulpesPosted Dec 26, 2012, 11:52 AM
Select * From Empinfo where Dateofjoining < '20000205'
Abdu RafeeqPosted Jan 1, 2013, 11:54 AM
Pranjal MishraPosted Dec 26, 2012, 10:57 PM
Akkiraju IvaturiPosted Dec 26, 2012, 11:57 AM
Select * From Empinfo where Dataofjoining < '2000-2-5'
Dates should be enclosed in single quotes and you can use >, <, = and between operators for date comparisons.