Error while conversion of string to datetime
Posted
by
aswathi
on Stack Overflow
See other posts from Stack Overflow
or by aswathi
Published on 2011-02-19T05:57:51Z
Indexed on
2011/02/19
7:25 UTC
Read the original article
Hit count: 229
The conversion of a char data type to a DateTime data type resulted in an out-of-range DateTime value. The statement has been terminated. Please give me most possible answers
ALTER PROCEDURE [dbo].[attendance_updatebyemployee_id]
@Employee_id int,
@AtDate datetime,
@FNLogged bit,
@ANLogged bit,
@LogTime varchar(10),
@LogOuttime varchar(10)
AS
BEGIN
SET NOCOUNT ON;
update Mst_Attendance set FNLogged=@FNLogged,
ANLogged=@ANLogged,LogTime=@LogTime,LogOuttime=@LogOuttime
where EmployeeId=@Employee_id and Atdate= @AtDate
END
© Stack Overflow or respective owner
