update datetime sqlserver

  • Thread starter Thread starter mcod3r
  • Start date Start date
M

mcod3r

i'm using an sqlcommand like this
"update mytable set myfielddatetime='" +
DatetTime.Now.ToString("G") + "'"

but when i execute it, i get an exception
(System.Data.SqlClient.SqlException)
that tell me : converting from char to datetime generated
a datetime overflow

how can i execute that query ?

thanks a lot
 
Try the full T-SQL implementation:

update mytable set myfielddatetime=GetDate()

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
Hi

Try doing this:

SqlCommand UpdateDate = new SqlCommand("update mytable set
myfielddatetime=@myfielddatetime",Connection);
UpdateDate.Parameters.Add("@myfielddatetime",SqlDbType.DateTime).Value =
DateTime.Now;
UpdateDate.ExecuteNonQuery();


Gary
 
Back
Top