/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 vote352 views1 answer
Blob datatype in mysql
SQL
2 votes356 views5 answers
SQL trigger
SQL
0 vote373 views2 answers
Oracle create tablespace autoextend
SQL
0 vote353 views1 answer
Initcap in sql
SQL
-1 vote379 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote382 views1 answer
Create synonym for dblink in oracle
SQL
0 vote303 views1 answer
Mysqli or pdo
SQL
0 vote373 views1 answer
Excel export from sql using python
SQL
0 vote388 views1 answer
How to retrive the today date sql
SQL
1 vote358 views1 answer
How to select the nth row in a SQL database table?
SQL

Share