IBM FileNet P8, Version 5.2.1            

timeunit_between

These functions return an integer that represents the number of either days or seconds between two times.

The syntax is as follows:
  • days_between(later_time, earlier_time)
  • seconds_between(later_time, earlier_time)
where the expressions later_time and earlier_time are of type time. If you change the order of the earlier time and the later time, the returned integer is negative.

For the days_between function, the passed times are truncated before the returned interval is calculated. For example, the difference between 8/10/1990 23:59:59 and 8/11/1990 0:0:0 is 1 second, but days_between returns a difference of one day. If your application needs more than plus-or-minus 24 hours accuracy, use the seconds_between function and then convert the returned number of seconds to the time unit that you need.

Tip: You can determine the number of seconds between two times by simply subtracting the times.


Last updated: March 2016
bpfe026.htm

© Copyright IBM Corporation 2016.