Sometimes door #1 isn’t the best option.
Option 3: DATEADD
DATEADD(dd, DATEDIFF(dd, 0 getdate()), 0)
Returns 2009-04-09 00:00:00.000 (shock horror!)
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
A dump of all things SQL Server, SQL Reporting Services, Analysis Services, around Business Intelligence, Business Performance Management and technology.
Training
Semi-Useful Posts
Blog Archive
-
▼
2009
(53)
-
▼
May
(8)
- Moving Database Files Detach/Attach or ALTER DATAB...
- Windows 7 and Windows Application Compatibility : ...
- Microsoft SQL Server Development Customer Advisory...
- Halving your delete times with large datasets
- Digital Volcano – Find and Replace multiple files
- BI-tch – Dropping the time in datetime
- Andrew Fryer's Blog
- RamDisk for Performance and Security
-
▼
May
(8)
Links
- 20 Useful MS Sites
- B-Eye Network
- BI Toolbelt
- Bullrunner, my Trading Blog
- Business Intelligence
- Certifiable, my Learning Blog
- Channel 9
- Code Formatter
- CodeBetter
- Connection Strings
- Curated USQL
- Data Mining - Alberto Roldan
- Data Model Examples
- DbVisualizer
- Digg
- Ella Maschiach's BI Blog
- Got Report Viewer
- Jesse Orosz
- MS Open Source Directory
- MS SQL Community
- MSDN Forums
- Microsoft
- My Sharepoint Blog
- PerformancePointing, My PerformancePoint Blog
- Proclarity Forum
- Robert Scoble
- SQL Common Questions
- SQL Formatter
- SQL PSS
- SQL Server Central
- SQL Server Videos
- SQL Server and XML
- SQLCat Whitepapers
- Silverlighting, my Silverlight Blog
- The I in BI
- Toad
- VHD Library
No comments:
Post a Comment