Tweet
As I said in my last post, today we are going to explore a VBScript function called DateDiff. There's not much mystery behind it, in fact, as the name says, DateDiff calculates the difference between two dates. The resulting value can be in different format and, generally speaking, the function can be used in many situations.
let's see how it works.
Showing posts with label datediff. Show all posts
Showing posts with label datediff. Show all posts
Thursday, 5 July 2012
Friday, 3 December 2010
SQL Server: basic functions (part 4) - Dates
Tweet
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:
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
Subscribe to:
Posts (Atom)