SELECT DATE(DATE_SUB('2004-07-30', INTERVAL DAYOFWEEK('2004-07-30')-2 DAY));
You need to subtract 2 in the interval because the "DAYOFWEEK" array starts with 1.
Sunday = 1 Monday = 2 etc.
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2017
(142)
-
▼
June
(45)
- Virtialise Physical Machine
- Vagrant Setup
- Vagrant File
- Vagrant
- Upgrading and Installing TFS
- Unistalling AVG E-Mail Server Edition
- TFS Permissions
- Tesseract OCR 3.0.5 Dev
- Tesseract Links
- Telnet, Console and AUX Port Passwords on Cisco Ro...
- Robocopy Folder Sync Script
- NLP LDA related links
- Network Level Authentication on Windows XP
- MySQL Password Update
- MySQL Max Pool Size
- Making a dashed line in d3
- LDAP Connection Strings
- IIS Redirect Setup
- D3 Examples
- Create your first Windows virtual machine in the A...
- Create PDF/A with Ghostscript
- Cisco Router Delete Static Entries
- Cisco Router Commands
- All ImageMagick Binaries URL
- Adding domain account email
- How to Install AntiSpam Agents in Exchange 2010
- Converting a date in MySQL from string field
- MySQL: week date range from week number in a query
- MySQL: Going from week of the year to date of the ...
- Is the Windows user ready for apt-get?
- Parse URL with jquery/ javascript?
- ASP.NET MVC - passing parameters to the controller
- Get SELECT's value and text in jQuery
- Improving Performance with Output Caching (C#)
- How to: Cache Versions of a Page Using Parameters
- How change List data to IQueryable data [duplicate]
- Fluent NHibernate Tutorial | C# Windows CRUD Example
- NHibernate: insert multiple items at once
- Process.start: how to get the output?
- Programmatically Adding Permissions to a Folder
- MySQL query String contains
- How to grant full permission to a file created by ...
- How to get username and SID for user by a domain n...
- FileSystemSecurity.AddAccessRule Method (FileSyste...
- PowerShell Get List Of Folders Shared
-
▼
June
(45)
No comments:
Post a Comment
Note: only a member of this blog may post a comment.