Time between two time stamps

[vishsaggi]

Hello ,

I am looking for a set analysis statement to check a timestamp field between two time intervals.

I have timestamp field with time I want to check this field between two times

like

Timestamp between Time1= 9:00:00 Am and Time2 = 11:00:00

Regards,
V.

[Gysbert_Wassenaar · Accepted solution]

Subtract the two times from each other: Time2 - Time1. You can use the interval function to format the result: interval(Time2-Time1, 'h:mm:ss').

If the time values are strings and not numbers then first convert them to numbers with the time# function. time#(Time1, 'h:mm:ss') as Time1. If they are timestamp strings then use the timestamp# function: timestamp#(MyTimeStamp, 'YYYY-MM-DD hh:mm:ss') as MyTimeStamp.

[nagarjuna_kotha]

Hi,

Can u share sample file ?

Regards,
Nagarjuna