/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 vote121 views1 answer
Not between mysql
SQL
2 votes113 views1 answer
Drop table purge
SQL
0 vote118 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote125 views1 answer
Start and stop mysql
SQL
2 votes81 views2 answers
Mysql get last character of string
SQL
0 vote117 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote100 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote112 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote112 views1 answer
Alter database name script
SQL
0 vote116 views1 answer
Mysql autoincrement valor inicial
SQL

Share