Problem With Searching Dates Again

after more than one week asking on the forum .. i get allways an erro searching on dates in MS SQL 2000

myDate = smalldatetime

SELECT myDate FROM dbo.myTable WHERE (myDate >= '2003-12-15') AND (myDate < '2003-12-16')

i get the error :conversion from CHAR to SMALLMONEY out of the limits

why smallmoney ??

if i try

myDate = datetime

SELECT myDate FROM dbo.myTable WHERE (myDate >= '2003-12-15') AND (myDate < '2003-12-16')


i get the error :conversion from CHAR to DATETIME out of the limits


so much time and energy lost for those dates !



thank you for helping again