How to search date converted to nvarchar in sql statement

Question

Dear All I want to appreciate this notable community for all the speedy tips they have given to me this increase my learning and development time. i currently have this challenge with my SQL script i want to extract data between 01-01-2008 and 31-12-2008 the result did not display all data in 2008 but show date from 2010 till 2016. this my code select * from dtl_patientRegister where left(convert(nvarcharARTStartDate110)10) between '01-01-2008' and '31-12-2008' still am not getting the expected result please kindly share with me any other way possible. thank you all

Dipika · Answer

If ARTstartdate is in datetime type then you dnt need to convert it to nvarchar just use the query select * from dtl_patientRegister where convert(datetime'ARTStartDate'104)between convert(datetime'01-01-2008'104) and convert(datetime'31-12-2008'104)

Nitin Sontakke · Answer

Keep this simple rule in mind: Whenever using dates in SQL Server always use a universally neutral date format which is yyyy-MM-dd. So if you write it as follows it will work. Convert the table column to just to Date and not to varchar or nvarchar etc.: between '2008-01-01' and '2008-12-31'

Ananth G · Answer

follow below path it may be help u http://stackoverflow.com/questions/19451767/datetime-between-statement-not-working-in-sql-server

Bikesh Srivastava · Answer

I am not getting your point can you show output what you want?.