Time point functions

Use time point functions to define and compare time points.
Note: When comparing two time points, milliseconds are not taken into account.

Date & time

Table 1. Functions for comparing time points
Syntax Description Example 
<date & time> is at the same time as <date & time>
 Checks that the two time points are identical, regardless of their time zone. 
if the arrival date of customer is at the same time as the beginning of 'promotional period'
 
<date & time> is after <date & time>
 Checks that the time point comes after another time point. 
if 'flight departure' is after 01/01/2018 12:OO:OO PM
 
<date & time> is after or the same as <date & time>
 Checks that the time point comes after another time point, or is the same as that other time point. 
if 'flight departure' is after or the same as 01/01/2018 12:OO:OO PM
 
<date & time> is before <date & time>
 Checks that the time point comes before another time point. 
if 'flight departure' is before 01/01/2018 12:OO:OO PM
 
<date & time> is before or the same as <date & time>
 Checks that the time point comes before another time point, or is the same as another time point. 
if 'flight departure' is before or the same as 01/01/2018 12:OO:OO PM
 
<date & time> is after <date & time> and before <date & time>
 Checks that the time point is in a range in which both time points are excluded. 
if 'flight departure' is after 01/01/2018 12:OO:OO PM and before 08/01/2018 12:OO:OO PM
 
<date & time> is after <date & time> and on or before <date & time>
 Checks that the time point is in a range in which the first time point is excluded, and the last time point is included. 
if 'flight departure' is after 01/01/2018 12:OO:OO PM and on or before 08/01/2018 12:OO:OO PM
 
<date & time> is on or after <date & time> and before <date & time>
 Checks that the time point is on or after a specific time point and before another time point. 
if 'flight departure' is on or after 01/01/2018 12:OO:OO PM and before 08/01/2018 12:OO:OO PM
 
<date & time> is on or after <date & time> and on or before <date & time>
 Checks that the time point is on or after a specific time point and on or before another time point. 
if 'flight departure' is on or after 01/01/2018 12:OO:OO PM and on or before 08/01/2018 12:OO:OO PM
 
<date & time> is in the same calendar week as <date & time>
 Checks that the two time points are in the same week. 
if the scheduled departure of flight is in the same calendar week as the start of 'trip period'
 
<date & time> is on the same calendar day as <date & time>
 Checks that the two time points are on the same day. 
if the scheduled departure of flight is on the same calendar day as the start of 'trip period'
 
<date & time> is in the same calendar month as <date & time>
 Checks that the two time points are on the same month. 
if the scheduled departure of flight is in the same calendar month as the start of 'trip period'
 
<date & time> is in the same calendar year as <date & time>
 Checks that the two time points are on the same year. 
if the scheduled departure of flight is in the same calendar year as the start of 'trip period'
 
<date & time> is in the same hour as <date & time>
 Checks that the two time points are in the same hour. 
if the scheduled departure of flight is in the same hour as the start of 'trip period'
 
<date & time> is in the same minute as <date & time>
 Checks that the two time points are in the same minute. 
if the scheduled departure of flight is in the same minute as the start of 'trip period'
 
<date & time> is in the same second as <date & time>
 Checks that the two time points are in the same second. 
if the scheduled departure of flight is in the same second as the start of 'trip period'
Table 2. Functions for comparing a time point and a time period
Syntax Description Example 
<date & time> is after <time period>
 Checks that the time point is at the same instant as the end of a specific period or later. 
if 'purchase event' is after 'flight period'
 
<date & time> is before <time period>
 Checks that the time point is earlier or at the same instant as the start of a specific period. 
if the departure time of flight is before the calendar month February 2013
 
<date & time> is during <time period>
 Checks that the time point takes place within a specific period. 
if 'purchase event' is during the period of 2 hours after the start of 'business trip'
 
<date & time> is within <calendar duration> before <date & time>
 Checks that the time point takes place within a calendar duration expressed in time units, and before another date. 
if 'ticket purchase' is within 2 hours before the scheduled departure of flight
 
<date & time> is within <calendar duration> after <date & time>
 Checks that the time point takes place within a calendar duration expressed in time units, and after another date. 
if 'return flight' is within 24 hours after the scheduled departure of 'outward flight'
Table 3. Functions for testing that a component of the representation of a time point has a specific value
Syntax Description Example 
<date & time> is at <time>
 Checks that the time point is at the specified time. 
if the return date of 'rented car' is at 05:00:00 PM
 
<date & time> is on <date>
 Checks that the time point is on a specific day. 
if the arrival date of customer is on 01/01/2018
 
<date & time> is on <day of week>
 Checks that the time point is on a specific day of the week. 
if the return date of 'rented car' is on Thursday
 
<date & time> is on <day of week> at <time>
 Checks that the time point is on a specific day of the week, at a specific time. 
if the return date of 'rented car' is on Thursday at 05:00:00 PM
 
<date & time> is on day <a number>
 Checks that the time point is on a specific day, specified by a number ranging from 1 to 31. 
if the arrival date of customer is on day 1
 
<date & time> is on <date & time>
 Checks that the two time points have the same date. 
if the arrival date of customer is on 01/01/2018 12:OO:OO PM
 
<date & time> is in hour <a number>
 Checks that the time point is on a specific hour. 
if 'flight departure' is in hour 13
 
<date & time> is in minute <a number>
 Checks that the time point is on a specific minute. 
if 'flight departure' is in minute 45
 
<date & time> is in second <a number>
 Checks that the time point is on a specific second. 
if 'flight departure' is in second 30
 
<date & time> is in <month>
 Checks that the time point is on a specific month. 
if 'flight departure' is in January
 
<date & time> is in <month> <year>
 Checks that the time point is in the specified month of the specified year. 
if 'flight departure' is in January 2019
 
<date & time> is in <year>
 Checks that the time point is in a specific year. 
if 'flight departure' is in 2019
Table 4. Accessor functions for time points
Syntax Description Example 
the number of <time unit> between <date & time> and <date & time>
 Returns the number of years, months, days, hours, minutes, or seconds between two time points. 
if the number of minutes between the connection time of customer and the beginning of 'promotional period' is less than 10
 
the duration in <time unit> between <date & time> and <date & time>
 Returns the number of time units between the two time points measured in the specified time unit, where the time unit is one of years, months, days, hours, minutes, or seconds. 
set 'training duration' to the duration in months between the beginning of training and the end of training
 
the <time component> of <date & time>
 Returns a time component of the specified time point, where the time component is one of year, month, day of month, day of week, hour of day, minute of hour, second of minute, date, or time of day. 
the day of week of the end of 'promotional period'
Table 5. Conversion functions for time points
Syntax Description Example 
the local time of <date & time> in <string>
 Converts the time point to a specific time zone, in the format defined by IANA 
set the local time of 'flight departure' in "Pacific/Midway"
 
the local time of <date & time> in the zone of <date & time>
 Converts the first time point to the time zone of the second time point. 
set the local time of 'flight departure' in the zone of 'flight arrival'

Date

Table 6. Functions for comparing time points
Syntax Description Example 
<date> is after <date>
 Checks that the date comes after another date. 
the beginning of 'promotional period' is after 01/01/2018
 
<date> is after or the same as <date>
 Checks that the date comes after another date, or is the same as that other date. 
the beginning of 'promotional period' is after or the same as 01/01/2018
 
<date> is before <date>
 Checks that the date comes before another date. 
the beginning of 'promotional period' is before 01/01/2018
 
<date> is before or the same as <date>
 Checks that the date comes before another date, or is the same as another date. 
the beginning of 'promotional period' is before or the same as the beginning of 'winter holiday'
 
<date> is after <date> and before <date>
 Checks that the date is in a range in which both dates are excluded. 
the beginning of 'promotional period' is after the beginning of 'winter holiday' and before 01/01/2018
 
<date> is after <date> and on or before <date>
 Checks that the date is in a range in which the first date is excluded, and the last date is included. 
the beginning of 'promotional period' is after the beginning of 'winter holiday' and on or before 01/01/2018
 
<date> is on or after <date> and before <date>
 Checks that the date is on or after a specific date and before another date. 
the beginning of 'promotional period' is on or after the beginning of 'winter holiday' and before 01/01/2018
 
<date> is on or after <date> and on or before <date>
 Checks that the date is on or after a specific date and on or before another date. 
the beginning of 'promotional period' is on or after the beginning of 'winter holiday' and on or before 01/01/2018
Table 7. Functions for testing that a component of the representation of a time point has a specific value
Syntax Description Example 
<date> is on <day of week>
 Checks that the date in on a specific day of the week. 
the beginning of 'promotional period' is on Sunday
 
<date> is on day <a number>
 Checks that the date is on a specific day, specified by a number ranging from 1 to 31. 
if the arrival date of customer is on day 1
 
<date> is in <month>
 Checks that the date in on a specific month. 
the beginning of 'promotional period' is in January
 
<date> is in <year>
 Checks that the date in on a specific year. 
the beginning of 'promotional period' is in the year 2018
 
<date> is in <month> the year <year>
 Checks that the date is in the specified month of the specified year. 
if the return date of 'rented car' is in October the year 2007
Table 8. Accessor functions for time points
Syntax Description Example 
the number of <time unit> between <date> and <date>
 Returns the number of years, months, or days between two dates. 
if the number of months between the subscription date of customer and the beginning of 'promotional period' is less than 3
 
the <time component> of <date>
 Returns a time component of the specified date where the time component is one of year, month, day of month, or day of week. 
the day of month of the beginning of 'promotional period'

Time

Table 9. Functions for comparing time points
Syntax Description   
<time> is after <time>
 Checks that the time point comes after another time point. 
if 'flight departure' is after 12:00:00 PM
 
<time> is after or the same as <time>
 Checks that the time point comes after another time point, or is the same as that other time point. 
if 'flight departure' is after or the same as 12:00:00 PM
 
<time> is before <time>
 Checks that the time point comes before another time point. 
if 'flight departure' is before 12:00:00 PM
 
<time> is before or the same as <time>
 Checks that the time point comes before another time point, or is the same as another time point. 
if 'flight departure' is before or the same as 12:00:00 PM
 
<time> is after <time> and before <time>
 Checks that the time point is in a range in which both time points are excluded. 
if 'flight departure' is after 12:00:00 PM and before 05:00:00 PM
 
<time> is after <time> and on or before <time>
 Checks that the time point is in a range in which the first time point is excluded, and the last time point is included. 
if 'flight departure' is after 12:00:00 PM and on or before 05:00:00 PM
 
<time> is on or after <time> and before <time>
 Checks that the time point is on or after a specific time point and before another time point. 
if 'flight departure' is on or after 12:00:00 PM and before 05:00:00 PM
 
<time> is on or after <time> and on or before <time>
 Checks that the time point is on or after a specific time point and on or before another time point. 
if 'flight departure' is on or after 12:00:00 PM and on or before 05:00:00 PM

Day of week

Table 10. Functions for comparing time points
Syntax Description   
<day of week> is after <day of week>
 Checks that the day of the week comes after another day of the week.
Note: Sunday is considered to be the first day of the week. 
if the day of the return date of 'rented car' is after Friday
 
<day of week> is after or the same as <day of week>
 Checks that the day comes after another day of the week, or is the same as that other day. 
if the day of the return date of 'rented car' is after or the same as Friday
 
<day of week> is before <day of week>
 Checks that the day of the week comes before another day of the week.
Note: Sunday is considered to be the first day of the week. 
if the day of the return date of 'rented car' is before Friday
 
<day of week> is before or the same as <day of week>
 Checks that the day comes before another day of the week, or is the same as another day of the week. 
if the day of the return date of 'rented car' is before or the same as Friday
 
<day of week> is after <day of week> and before <day of week>
 Checks that the day is in a range in which both days are excluded. 
if the day of the return date of 'rented car' is after Friday and before Sunday
 
<day of week> is after <day of week> and on or before <day of week>
 Checks that the day is in a range in which the first day is excluded, and the last day is included. 
if the day of the return date of 'rented car' is after Friday and on or before Sunday
 
<day of week> is on or after <day of week> and before <day of week>
 Checks that the day is on or after a specific day of the week and before another day. 
if the day of the return date of 'rented car' is on or after Friday and before Sunday
 
<day of week> is on or after <day of week> and on or before <day of week>
 Checks that the day is on or after a specific day of the week and on or before another day. 
if the day of the return date of ’rented car’ is on or after Friday and on or before Sunday

Month of year

Table 11. Functions for comparing time points
Syntax Description   
<month of year> is after <month of year>
 Checks that the month comes after another month of the year. 
if 'promotional period’ is after June
 
<month of year> is after or the same as <month of year>
 Checks that the month comes after another month of the year, or is the same as that other month. 
if 'promotional period' is after or the same as June
 
<month of year> is before <month of year>
 Checks that the month comes before another month of the year. 
if 'promotional period' is before May
 
<month of year> is before or the same as <month of year>
 Checks that the month comes before another month of the year, or is the same as another month. 
if 'promotional period' is before or the same as May
 
<month of year> is after <month of year> and before <month of year>
 Checks that the month is in a range in which both months of the year are excluded. 
if 'promotional period' is after May and before September
 
<month of year> is after <month of year> and on or before <month of year>
 Checks that the month is in a range in which the first month is excluded, and the last month is included. 
if 'promotional period' is after May and on or before September
 
<month of year> is on or after <month of year> and before <month of year>
 Checks that the month is on or after a specific month of the year and before another month. 
if 'promotional period' is on or after May and before September
 
<month of year> is on or after <month of year> and on or before <month of year>
 Checks that the month is on or after a specific month of the year and on or before another month. 
if 'promotional period' is on or after May and on or before September

Year

Table 12. Functions for comparing time points
Syntax Description   
<year> is after <year>
 Checks that the year comes after another year. 
if 'flight departure' is after 2018
 
<year> is after or the same as <year>
 Checks that the year comes after another year, or is the same as that other year. 
if 'flight departure' is after or the same as 2018
 
<year> is before <year>
 Checks that the year comes before another year. 
if 'flight departure' is before 2018
 
<year> is before or the same as <year>
 Checks that the year comes before another year, or is the same as another year. 
if 'flight departure' is before or the same as 2018
 
<year> is after <year> and before <year>
 Checks that the year is in a range in which both year are excluded. 
if 'flight departure' is after 2018 and before 2020
 
<year> is after <year> and on or before <year>
 Checks that the year is in a range in which the first year is excluded, and the last year is included. 
if 'flight departure' is after 2018 and on or before 2020
 
<year> is on or after <year> and before <year>
 Checks that the year is on or after a specific year and before another year. 
if 'flight departure' is on or after 2018 and before 2019
 
<year> is on or after <year> and on or before <year>
 Checks that the year is on or after a specific year and on or before another year. 
if 'flight departure' is on or after 2018 and on or before 2019