Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT d.draftID_PK,
- d.clientID_FK,
- count(d.quoteNr) AS totalquote,
- DATE_FORMAT (d.draftDate,'%u %M %Y') as draftDate,
- c.clientName
- FROM draft d
- INNER JOIN client c ON c.clientID_PK = d.clientId_FK
- WHERE d.draftDate<CURDATE() AND d.draftDate>'2013-01-05'
- AND c.clientName = '{$client_name}'
- GROUP BY DATE_FORMAT (d.draftDate,'%u')
- ORDER BY d.draftDate DESC
- SET @date:='2014-08-31';
- SELECT
- @first := date_add(
- date_add(
- LAST_DAY(@date),
- interval 1 DAY
- ),
- interval -1 MONTH
- ) AS first_day,
- @date,
- -- EXAMPLE 1
- WeekofYear(@date),
- WeekofYear(@first),
- WeekofYear(@date)-(WeekofYear(@first)-1) Num_Week,
- -- EXAPLE 2 - Works in Brazil perfectly
- Week(@date),
- Week(@first),
- Week(@date)-(Week(@first)-1) Num_Week_Brazil
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement