Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two time stamps start and end in the format 1/1/2015 7:30:00 AM. How do I go about getting the seconds between the two time stamps?
You have an internal representation of timestamps that makes it possible to just subtract one from the other.
It will still be in days so you could multiply them up to seconds: 24 hours * 60 minutes * 60 seconds = 86400
SecondsDiff = ( Timestamp1 - Timestamp2 ) * 86400
This will however make the result into a regular number - and you will not have a timestamp anymore. Using Interval() would solve that.
Maybe like this:
Interval(StartStamp - EndStamp, 'ss')
Interval(EndStamp - StartStamp, 'ss')
You have an internal representation of timestamps that makes it possible to just subtract one from the other.
It will still be in days so you could multiply them up to seconds: 24 hours * 60 minutes * 60 seconds = 86400
SecondsDiff = ( Timestamp1 - Timestamp2 ) * 86400
This will however make the result into a regular number - and you will not have a timestamp anymore. Using Interval() would solve that.
(TimestampEnd-TimestampStart)*86400
wow.
3 answers in the same minute ...
It's perfect I love that - Qlik products deserve to have a highly responsive community