Welcome to jBASE's new documentation site! Many answers to your questions can be found by searching the Knowledgebase or viewing the jBASE Documentation. We also have a Google Group for peer discussion about jBASE. If you are unable to find the information you are looking for, jBASE Support will be glad to assist in resolving your technical problems. Enjoy and please provide comments and feedback .

How can we help you?

TIMEDIFF

Description

This function returns the interval between two timestamp values as a dynamic array. It takes the general form:

TIMEDIFF(Timestamp1, Timestamp2,Mask)

Where: 

timestamp1 and timestamp2 are timestamp values to be subtracted. 

the Mask is an integer from 0 to 7 and selects one of the following output formats:

Mask
Array
0
Days^Hours^Minutes^Seconds^Milliseconds (Default)
1
Weeks^Days^Hours^Minutes^Seconds^Milliseconds
2
Months^Days^Hours^Minutes^Seconds^Milliseconds
3
Months^Weeks^Days^Hours^Minutes^Seconds^Milliseconds
4
Years^Days^Hours^Minutes^Seconds^Milliseconds
5
Years^Weeks^Days^Hours^Minutes^Seconds^Milliseconds
6
Years^Months^Days^Hours^Minutes^Seconds^Milliseconds
7
Years^Months^Weeks^Days^Hours^Minutes^Seconds^
Milliseconds

The TIMEDIFF function returns the interval between two timestamp values . The interval is returned as an attribute delimited array of the time difference.


Go back to jBASE BASIC.

Was this article helpful?