/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

0 vote176 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
3 votes142 views4 answers
Psql list tables in schema
SQL
3 votes191 views2 answers
How to View column names of a table in SQL
SQL
0 vote129 views2 answers
How to start postgresql laravel
SQL
2 votes158 views1 answer
Capitalize 1st letter in sql server
SQL
17 votes270 views4 answers
Show all tables in oracle
SQL
0 vote142 views1 answer
Contact mysql column field
SQL
7 votes144 views1 answer
Sql disable safe mode
SQL
11 votes152 views1 answer
Sql insert multiple rows from select
SQL
0 vote141 views1 answer
Mysql two joins
SQL

Share