Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

Get monday of week date is in SQL

DateAdd(day, (-1* (DatePart(weekday, TIMESTAMP)  % 7)) + 2, TIMESTAMP)
-- If first day is sunday in SQL
 
PREVIOUS NEXT
Tagged: #Get #monday #week #date #SQL
ADD COMMENT
Topic
Name
7+4 =