c# - Error in Updating a table using datetime as parameter in Stored procedure -

the conversion of char data type datetime data type resulted in out-of-range datetime value. statement has been terminated.

alter procedure [dbo].[attendance_updatebyemployee_id] @employee_id int, @atdate datetime, @fnlogged bit, @anlogged bit, @logtime varchar(10), @logouttime varchar(10)   begin          set nocount on;         update mst_attendance set fnlogged=@fnlogged,     anlogged=@anlogged,logtime=@logtime,logouttime=@logouttime      employeeid=@employee_id , atdate= @atdate  end 

in c# code give

 cmd.parameters.addwithvalue("@atdate",dtime.tostring("dd/mmm/yyyy")); 

while using sql profiler.the data passed is

exec [dbo].[attendance_updatebyemployee_id] @employee_id=2,@atdate='feb 19 2011 12:00:00:000am',@fnlogged=1,@anlogged=0,@logtime='11:45 am',@logouttime=' '  

inside stored procedure @atdate has value 2011-02-19 00:00:00.000. breaking update command.

inside table date saved 2/19/2011 12:00:00 am

how can solve date problem.

if have tool use sql profiler see exact sql string passed database. find error.