MSSQL date search

[Mr Anderson]

I'm trying to get a date search working with MSSQL and for some reason it's not returning any results. I'm not sure if the SQL for MSSQL for date searches should differ from MySQL?

The code I'm trying to use is:

Code:

SELECT StartTimeStamp, Duration, CallDirection, ExternalNumber, Filename FROM IpPbxCDR.dbo.CFData
WHERE ExternalNumber = 'xyz' AND StartTimeStamp >= '11-06-01' AND StartTimeStamp <= '11-06-07'
ORDER BY StartTimeStamp DESC

The StartTimeStamp is stored in the DB as YY-MM-DD HH:MM:SS and is the type timestamp. I'm also using PHP so using ADODB to connect (I'm not sure if that makes a difference).
 
Any suggestions welcome.

[samhs]

use datediff() and compare for a positive (or negative) number instead of > or < - I can't ever get less than or greater than to work consistently with date comparisons.

[Dom]

The thing I've found with dates is that it can be a bit funny if you don't include a time. I've not really found a reliable way to use date comparisons myself, so I might try samhs' suggestion above next time I have some troubles.

[Mr Anderson]

The thing I've found with dates is that it can be a bit funny if you don't include a time. I've not really found a reliable way to use date comparisons myself, so I might try samhs' suggestion above next time I have some troubles.

Give it a go, it's worked for me

use datediff() and compare for a positive (or negative) number instead of > or < - I can't ever get less than or greater than to work consistently with date comparisons.

Cheers Sam, that saved me a headache