Skip to content
Advertisement

Update only time from my Datetime field in sql

I have a date 2013-12-14 05:00:00.000 in my table.

Now i want to update only time of that date. E.G to 2013-12-14 04:00:00.000

Is there any query to update only time from datetime field?

Advertisement

Answer

Or this

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement