Update Time on DateTime Field in SQL Server
Posted on 2006-07-13
I'm working on an ASP.NET application that will update times from a table. I have a stored procedure to select the data that formats the date as a time value only, for example 16:00. In the SQL table the value is stored as "11/22/2005 4:00:00 PM".
My problem is that I need to update the time, but keep the same date, in my ASP.NET application. For example, change "11/22/2005 4:00:00 PM" to "11/22/2005 5:30:00 PM." I'm having problems passing the values to the table in an update statement.
I hope I'm making sense. Any help is greatly appreciated as this is very urgent!