Sql update a date column

Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Visit chat. Linked 1. Related Hot Network Questions. The update query does not need a sub-query. It should be like so:. That being said, there is absolutely no need to store same information twice in a table.

If you want your datetime in a specific format, format it on demand:. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked yesterday. Collectives on Stack Overflow.

Learn more. Asked 9 years, 1 month ago. Active 1 year, 10 months ago. Viewed k times. Does anyone know how I would change the date to the one desired? Improve this question. BryanH 5, 3 3 gold badges 35 35 silver badges 47 47 bronze badges.

Stack Over Stack Over 1 1 gold badge 3 3 silver badges 4 4 bronze badges. Define Not Working Error messages? Can I also suggest an alternative for SQL onwards, which personally I find easier to read as I'm not mathematically minded:. Related Articles. SQL Server function to convert integer date to datetime format. Handle conversion between time zones in SQL Server - part 1.

Creating a date dimension or calendar table in SQL Server. Popular Articles. Rolling up multiple rows into a single row and column for SQL Server data. How to tell what SQL Server versions you are running.