Answers for "sql server from week number to starting monday"

SQL
1

sql week number starting monday

BEGIN TRANSACTION;

/* Table Creation And Insertions */
CREATE TABLE week(Number integer PRIMARY KEY, Name text);
  INSERT INTO week VALUES(1, 'Monday')
  INSERT INTO week VALUES(2, 'Tuesday')
  INSERT INTO week VALUES(3, 'Wednesday')
  INSERT INTO week VALUES(4, 'Thursday')
  INSERT INTO week VALUES(5, 'Friday')
  INSERT INTO week VALUES(6, 'Saturday')
  INSERT INTO week VALUES(7, 'Sunday')
COMMIT;

/* Queries */
SELECT name AS 'Day'
FROM week
WHERE name = 'Monday';

/* Returns Monday' */
Posted by: Guest on July-26-2021
1

sql server week number

datepart(wk, DateToParse)
Posted by: Guest on March-18-2020

Code answers related to "sql server from week number to starting monday"

Code answers related to "SQL"

Browse Popular Code Answers by Language