DATE_FORMAT(subdate(MB.InsertDTS, INTERVAL weekday(MB.InsertDTS) DAY), '%m/%d/%Y') AS InsertDTSWeek,
DATE_FORMAT(DATE_ADD(LAST_DAY(DATE_SUB(MB.InsertDTS, interval 30 day)), interval 1 day), '%m/%d/%Y') AS InsertDTSMonth,
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment