vendredi 12 juin 2015

How to compare two date in SQL Server 2005?

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. 1-06-2015
  2. 10-06-2015
  3. 1-07-2015

I cannot use Format Method because 2005 not support. I tried Convert method but not helpful.

Aucun commentaire:

Enregistrer un commentaire