>>SQL Server 2005 and less:
>>
>>select * from myTable where MyDateTime >= '19000101' and MyDateTime < '19000102'
>
>Funny I was using the syntax you have shown below (for SQL 2005 or less) and didn't work. But I probably mistypes something and didn't even look close. Thank you for your help.
You're welcome :)
If it's not broken, fix it until it is.
My Blog