addHours

Return the sum of a date value and a specified number of hours.

Example

Add 36 hours to the dates in TIME_ID.

addHours(Sales_Acme.Sales.TIME_ID, 36)

Syntax

addHours(date expr d, int h)
  • d : date to add hours to
  • h : int hours to add to d

    Returns

    date

Notes

Adds an integer number (+/-) of hours to a date given in the format “yyyy-MM-dd”, and returns the final date as a result.