How can I convert date value into format of dd-MM-yyyy in SQL? I have stored date into database in varchar(10) format. Now want to compare date from 1-05-2015 to 31-06-2015.
Query is :
select date
from dates
where date >='1-05-2015' and date <='10-06-2015'
it returns only (same result in use of between)
- 1-06-2015
- 10-06-2015
- 1-07-2015
I cannot use Format Method because 2005 not support. I tried Convert method but not helpful.
Aucun commentaire:
Enregistrer un commentaire