Help on the following SQL server Select query

[inlovewithmusic]

SELECT *
FROM jake19812ce655. .FIREFOX_Memory
WHERE Date >= 2008-08-27 04:33:00
AND Date <= 2008-08-27 04:34:23


hi ..when running the above given query I am getting an error message that says
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ':'.

I dont understand what's wrong as the date column in FIREFOX has valid
rows with date/time values in them

[ck9663]

SELECT *
FROM jake19812ce655. .FIREFOX_Memory
WHERE Date >= 2008-08-27 04:33:00
AND Date <= 2008-08-27 04:34:23


hi ..when running the above given query I am getting an error message that says
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ':'.

I dont understand what's wrong as the date column in FIREFOX has valid
rows with date/time values in them

WHERE Date >= cast('2008-08-27 04:33:00' as datetime)

That is if your Date column is of datetime data type

--- CK

[shenliang1985]

select startdate from fortest;
--startdate is a datetime type
--the following are startdate's records in  table fortest
startdate
2008-08-08 12:12:12.000
2008-08-21 21:21:21.000
2006-07-07 00:00:00.000
2009-09-09 00:00:00.000
2008-08-08 12:12:12.000

select startdate from fortest where startdate <'2009-09-09 10:00:00.000' and startdate>'2006-07-07 00:00:00.000'
--now result
startdate
2008-08-08 12:12:12.000
2008-08-21 21:21:21.000
2009-09-09 00:00:00.000
2008-08-08 12:12:12.000