How to search date converted to nvarchar in sql statement

Abraham Olatubosun

10y904SQL

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(nvarchar,ARTStartDate,110),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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

John10y ago
Accepted 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)
+1
Nitin Sontakke10y ago
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'
0
Ananth G10y ago
follow below path it may be help u
http://stackoverflow.com/questions/19451767/datetime-between-statement-not-working-in-sql-server
0
Bikesh Srivastava10y ago
I am not getting your point ,can you show output what you want?.
0