I want to calculate in seconds the difference between the current Date/Time and a previous Date/Time
eg. [Current Date/Time] - [Yesterday Date/Time] = xxx sec
milleg1 (BOB member since 2008-10-16)
I want to calculate in seconds the difference between the current Date/Time and a previous Date/Time
eg. [Current Date/Time] - [Yesterday Date/Time] = xxx sec
milleg1 (BOB member since 2008-10-16)
You have to calculate it at database level.
Date1- Date2 * 86400
rohit12 (BOB member since 2008-11-08)
This topic may help:
Marek Chladny (BOB member since 2003-11-27)