Sql command to update date field

I just use variables and all set. I used that and added the time after the date and it worked — FernandoZ. Add a comment. Normally, it should work. But can you try this? Robotnik 3, 2 2 gold badges 29 29 silver badges 46 46 bronze badges. Serkan Hekimoglu Serkan Hekimoglu 4, 5 5 gold badges 36 36 silver badges 62 62 bronze badges. This worked, but I tried it before without all zeros and it did not work. I tried it with ' Nice, seriously dont have any idea. Because you wrote without time information, and SQL must attach default So it must be worked.

If it says 'One record changed' then perhaps you need to show us how you verify Remus Rusanu Remus Rusanu k 39 39 gold badges silver badges bronze badges.

Collectives on Stack Overflow. Learn more. Ask Question. Asked 12 years, 7 months ago. Active 8 years, 5 months ago. Viewed 95k times. Improve this question. Community Bot 1 1 1 silver badge.

Joshua Carmody Joshua Carmody I have no doubt I could have found the answer on my own. But since StackOverflow seems to be aspiring to be a repository of all programming knowledge, and this question hadn't been asked yet, I figured "why not?

Joshua, see my comment to Kev under my answer. Updating Date field in a mdb file. How to modify the update command to omit a rowguid column. Update command with parameters problem. Mobile Development. How to use Nuget assembly as files with visual studio community. Opening Balance. Follow us! Get the Latest Bytes Updates. The backup will help you revert the changes if the result is not as expected.

You could also run the update in a transaction and rollback if needed. This is the quickest and easy way to address such situations. Also, we will just update certain rows again. As you can see, you can use a function to change the day of the month to any specific day you want.

Caution: Make sure you use an appropriate WHERE clause before you run the UPDATE statement and ensure you take a table backup before you make any changes, it will help you to rollback changes to previous state in case of any accidental updates. You can use dateadd function to change the month to any specific month you want. You can use the DATEADD function to change the day, month, year, quarter, dayofyear, week, weekday, hour, minute, second, milliseconds, microsecond and nanosecond as needed.