How to convert var char value into date time format
i have inserting var-char value like '3-2017' into column name (Test) . means month and year now i want to search records between '3-2017' to '5-2017' please help me how to fetch those recordsselect *
from Testable
where Test > ='3-2017'
and Test <='5-2017'
i have tried above query but i'm not getting proper results
Thanks,
Advance.