Using TIME difference calculated fields
8 November, 2011
We have seen the HOUR time Difference but can we include the Minutes and seconds for this?
I also just want to confirm if this TIME Difference only works for SQL Server or it can also work to other DB's such as MYSQL, Oracle and Sybase?
Thanks, Albert
Hi Albert,
The Time difference calculated fields do depend on your DB, and what operators they support.
Oracle and MySQL do support these fields, though they are slightly different.
E.g. SQL Server has 'HOURS between' . Oracle has 'DAYS between'.
However even though they are slightly different the calculation should be the same, and you can then choose to display the data in hours/minutes/ seconds etc.. which should give you the results you were after (see screenshot below):
Please let me know if this doesn't give you the results you were after.
Also, what database is your view based on?
Regards,
David
The Time difference calculated fields do depend on your DB, and what operators they support.
Oracle and MySQL do support these fields, though they are slightly different.
E.g. SQL Server has 'HOURS between' . Oracle has 'DAYS between'.
However even though they are slightly different the calculation should be the same, and you can then choose to display the data in hours/minutes/ seconds etc.. which should give you the results you were after (see screenshot below):
Please let me know if this doesn't give you the results you were after.
Also, what database is your view based on?
Regards,
David
Hi David,
Okay, we'll try this one. Is there a way we can also add SECONDS for the TIME DIFF?
Thank you so much,
Albert
Okay, we'll try this one. Is there a way we can also add SECONDS for the TIME DIFF?
Thank you so much,
Albert
Hi Albert,
At the moment there is no time difference for Minutes/Seconds.
An enhancement request has been created (TASK ID = 108874) which can hopefully be implemented in a future build.
The only workaround for this is to create either a freehand calculated field / Virtual table so you can run the query directly against your DB.
Regards,
David
At the moment there is no time difference for Minutes/Seconds.
An enhancement request has been created (TASK ID = 108874) which can hopefully be implemented in a future build.
The only workaround for this is to create either a freehand calculated field / Virtual table so you can run the query directly against your DB.
Regards,
David