I am trying to update the time only in my datetime
column in SQL Server.
I have these columns in my tblAttendance2
DateTimeIn, DateTimeOut, UserID
I want to update the time for my time in and time out on a specific day (WHERE
).
Thanks
datetimesqlsql-server-2008
I am trying to update the time only in my datetime
column in SQL Server.
I have these columns in my tblAttendance2
DateTimeIn, DateTimeOut, UserID
I want to update the time for my time in and time out on a specific day (WHERE
).
Thanks
Best Answer
This should work:
... edited.. I had MySQL syntax and not SQL2008 originally.