Showing posts with label datename. Show all posts
Showing posts with label datename. Show all posts

Friday, 3 December 2010

SQL Server: basic functions (part 4) - Dates

   


Dates! Working with dates in Sql Server queries might be fun... or not... It's a fact that sooner or later everybody will end up dealing with date manipulation. Sql Server comes with different date functions which can help us through the process. In this article we are going to see:
  • datepart
  • day, month, year
  • datename
  • getdate
  • dateadd
  • datediff