DATEDIFF





This function returns an interval between two dates.

Parameters:

  • Expression. Type: Date.
  • Expression. Type: Date.
  • Difference type. One of the following values:
  • Second
  • Minute
  • Hour
  • Day
  • Month
  • Quarter
  • Year

DATEDIFF(DATETIME(2009, 10, 12, 10, 15, 34),
    DATETIME(2009, 10, 14, 9, 18, 06),
    "Day")

Result:

2


Comments
0
Add comment