Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In a table i have two times, what i need is to know how many seconds have elapsed between the two times.
With this sintax i get the hour and minuts but i need the seconds.
interval([Hora Fin] - [Hora Inico]) as Time
Thanks
Hi,
You are almost there! Use the following format to show the result in seconds:
Interval([Hora Fin] - [Hora Inicio], 's') as Time
The 's' will make the Interval() be displayed in seconds.
Hope that helps.
BI Consultant
Hi,
You are almost there! Use the following format to show the result in seconds:
Interval([Hora Fin] - [Hora Inicio], 's') as Time
The 's' will make the Interval() be displayed in seconds.
Hope that helps.
BI Consultant
Thanks!
You're right