-
December 24th, 2001, 08:25 AM
#1
Sql Server Error
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|