Mysql Posted November 25, 2019 Share Posted November 25, 2019 Being an SQL Newbie, I have a table where I want to extract the weekday from one column and insert it into another, see screenshot attached Had no luck so far, any help appreciated Txs M. Link to comment Share on other sites More sharing options...
niche Posted November 25, 2019 Share Posted November 25, 2019 (edited) https://www.w3schools.com/sql/sql_update.asp Just substitute col name for value. Edited November 25, 2019 by niche Link to comment Share on other sites More sharing options...
Mysql Posted November 26, 2019 Author Share Posted November 26, 2019 THANKS ! Link to comment Share on other sites More sharing options...
Sherin Posted March 20, 2020 Share Posted March 20, 2020 you can try this formula when date is insert and automatically weekday is displayed datename(dw,[date]) Link to comment Share on other sites More sharing options...
Ingolme Posted March 20, 2020 Share Posted March 20, 2020 Please do not reply to old topics. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now