sql SELECT query problem, using dates

[willmoss]

Can anyone help me? This thing is driving me up the wall!

I spent all yesterday afternoon working out how to create a new user in Microsoft SQL (use stored procedure "sp_adduser" for anyone who finds themselves in this situation!) then, when I logged in as this new user, the damned thing started giving me grief executing a SELECT query using dates...



I am trying to execute this query:

SELECT * FROM meetings WHERE [date] > '15/09/2004 15:00:07' AND [date] < '15/11/2004 15:00:07';

.. and I get the following error:

Microsoft OLE DB Provider for SQL Server error '80040e07' 
 
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

So, I tried removing the apostrophes:

SELECT * FROM meetings WHERE [date] > 15/09/2004 15:03:06 AND [date] < 15/11/2004 15:03:06;

.. and got the following error:

 Microsoft OLE DB Provider for SQL Server error '80040e14' Line 1: Incorrect syntax near '15'.

WHAT IS GOING ON ??!

the column [date] is formatted as datetime

I'm using Microsoft SQL Server v8.

If anyone has any ideas, I would be really grateful for some help. This thing has been driving me mad!!

[r937]

suggest you enter your date strings in yyyy-mm-dd format

e.g. WHERE [date] > '2004-09-15 15:00:07' AND [date] < '2004-11-15 15:00:07';