/SQL/Last working day in week date function in sql

Last working day in week date function in sql

Sql last week

select min(date), max(date)
from calendar
where week = datepart(week, getdate() - 7)
and year = datepart(year, getdate() - 7)

1

Source: stackoverflow.com

Date sql get the last week count

select * from dt_table where  `date` >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)

0

Source: plus2net.com

Similar codes

1 vote215 views1 answer
Mysql select another database
SQL
0 vote224 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
3 votes218 views1 answer
Oracle apex call duration
SQL
0 vote217 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
5 votes228 views4 answers
Change auto increment mysql
SQL
3 votes209 views1 answer
Force using index plsql
SQL
5 votes232 views1 answer
Oracle nls session
SQL
0 vote246 views1 answer
Prisma transaction
SQL
0 vote225 views1 answer
Create dump file mysql workbench
SQL
0 vote230 views1 answer
How do you insert boolean to postgresql
SQL

Share