run date query in nvarchar type, how ?

[E_Gold]

hi how i can run this: select * from men where Tdate between 01/01/01 and 02/02/02 but, Tdate is nvarchar type i work with sqlCE thank's

[Luc Pattyn]

Hi, I would convert the string to a real datetime using convert(datetime, Tdate), then use that in a WHERE clause. it could be something like ... where convert(datetime, Tdate, 1)>='01/01/01' and convert(datetime, Tdate, 1)<='02/02/02' The '1' code specifies the format, see here[^]. I would also suggest to STORE dates as such, not as strings. :)

Luc Pattyn

---

Local announcement (Antwerp region): Lange Wapper? Neen!

---

[Mycroft Holmes]

Luc has given you the solution but he was not forceful enough on storing the data as a datetime data type. If you do not change your data format to datetime then you will continiously run into this problem and all the associated datetime issues we see here regularly. STORE YOUR DATA IN THE RIGHT FORMAT.

Never underestimate the power of human stupidity RAH

[Luc Pattyn]

Mycroft Holmes wrote:

he was not forceful enough

Sorry, I must be having an off-day then. :)

Luc Pattyn

---

Local announcement (Antwerp region): Lange Wapper? Neen!

---

[Mycroft Holmes]

As we are no longer encouraged to beat them with the sarcasm stick :sigh: , I see no reason not to scream it in their face.

Never underestimate the power of human stupidity RAH

[Lost User]

Mycroft Holmes wrote:

As we are no longer encouraged to beat them with the sarcasm stick Sigh , I see no reason not to scream it in their face.

Even though neither method has the desired effect in too many cases :mad: