MaximumASP
Social Bookmarking
Online Shopping
asp.net hosting
UK online local dating
| More
Recent News » SQL

SQL SERVER - Few Useful DateTime Functions to Find Specific Dates

Posted by: Journey to SQL Authority with Pinal Dave, on 29 Aug 2008 | View original | Bookmarked: 0 time(s)

Recently I have recieved email from Vivek Jamwal, which contains many useful SQL Server Date functions. —-TodaySELECT GETDATE() ‘Today’—-YesterdaySELECT DATEADD(d,-1,GETDATE()) ‘Yesterday’—-FirstDayofCurrentWeekSELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) ‘FirstDayofCurrentWeek’—-LastDayofCurrentWeekSELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) ‘LastDayofCurrentWeek’—-FirstDayofLastWeekSELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) ‘FirstDayofLastWeek’—-LastDayofLastWeekSELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),6)...

Advertisement
Free Agile Project Management Tool from Telerik
TeamPulse Community Edition helps your team effectively capture requirements, manage project plans, assign and track work, and most importantly, be continually connected with each other.
Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 863 | Hits: 35

Similar Posts

  • Eschewing Date Types in our Database more
  • LINQ Tip of the week: System.DateTime support more
  • Eloquera Database - the web-oriented client/server object database for .NET more
  • Script to Inventory Print Servers more
  • New Date Data Types in Microsoft SQL Server 2008 more
  • Repairing SQL 2005 Business Intelligence Studio after uninstalling VS2005 more
  • New Sophisticated SQL Injection Attack more
  • SQL Server Compact Edition 3.5 more
  • A Library For Executing SQL Scripts With GO Separators and Template Parameters more
  • How to debug a stored procedure in your Sql Server 2005 more

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD