Hi Gurus
i am firing this Sql on Sql Server 7.0 database

Select * from zones
Where EntryDate > CONVERT( SMALLDATETIME ,'17/12/2001 12:00:00 AM')

where EntryDate is a datetime field.

But i am getting a error as below..

The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

i am trying my level best but unable to solve till now.
if any one can help me please try to solve this problem.


Thanks...
AbhiDesh