DAY_INTERVAL macro
The
DAY_INTERVAL
macro is available only in
IBM
®
Campaign
.
Syntax
DAY_INTERVAL(from_year, from_month, from_day, to_year, to_month, to_day)
Parameters
from_year
Valid 2-digit or 4-digit year number.
from_month
Valid month number between 1-12.
from_day
Valid day number between 1-31.
to_year
Valid 2-digit or 4-digit year number.
to_month
Valid month number between 1-12.
to_day
Valid day number between 1-31.
Description
DAY_INTERVAL
returns the number of days between the specified from date (
from_year/from_month/from_day)
and the specified to date
(to_year/to_month/to_day)
.
Examples
DAY_INTERVAL(2000,8,31,2000,12,31)
returns the number 122.
Related functions
Function
Description
DAY_BETWEEN
Returns the number of days between two specified date strings.
DAY_FROMNOW
Returns the number of days between the current day and a specified date.
Copyright IBM Corporation 2015. All Rights Reserved.