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

Next page: CURRENTDATE


Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.