BETWEEN Query

[grimmy]

I am trying to find a set of results within two dates and I am using the follwing query which is failing:-

select * from Employee where PTW BETWEEN '24/07/2002' AND '24/07/2001'

The error I am getting is:-
The conversion of CHAR to DATETIME resulted in a DATETIME value out of range.

The column has a data type of DateTime and I am using SQL 6.5.

Any help will be much appreciated.

 

[cheyney]

try this:


select * from Employee where PTW BETWEEN CAST('24/07/2002' as datetime) AND CAST('24/07/2001' as datetime)

 

[JayKusch]

or this ...


select * from Employee where PTW BETWEEN Convert(datetime,'7/14/2001') AND Convert(Datetime,'7/24/2002')

Thanks

J. Kusch

 

[sunila7]

Hi,

Also Try this.... as the default dateformat for SQL server is mdy.

select * from Employee where PTW BETWEEN '07/24/2002' AND '07/24/2001'.

Sunil