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