Showing posts with label datediff. Show all posts
Showing posts with label datediff. Show all posts

Thursday, 5 July 2012

ASP: how to use datediff

   


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.

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