Interval Date/Time index tab

[brjohnsmith]

Hi,
suppose that I have the scenario:

index 1 datetime (01/01/2023 10:00 am)
index 2 datetime (01/01/2023 11:00 am)
index 3 datetime (01/01/2023 02:00 pm)
index 4 dateitme (01/01/2023 04:00 pm)
index 5 datetime (01/01/2023 06:00 pm)

these indexes are in only one database. note that datetime is an unique field value, but depending on the index, there will be a different date time.

now I need to know 2 things.

1. how to get the interval among them
2. how to get the interval for the specific index

for the item 1 - example the result would be:

index 1 - 0
index 2 - 01:00
index 3 - 03:00
index 4 - 02:00
index 5 - 02:00

for the item 2 - supposing now that I need to know the interval among 1 and 2, 3 and 4

index 1 - 0
index 2 - 01:00
index 3 - 0
index 4 - 02:00
index 5 - 0

note: the results are related to the interval.

how to index in the same databand and field? for the second, there is an index value that it can be used such as: datetime.1 (means index 1), etc.

thx.

[Lech Kulikowski]

Hello,

Sorry, we did not exactly understand your task. Please send us test data on how it is present in your database for analysis.

Thank you.