Difference in seconds between Current Date/Time & Previo

[system]

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)

[system]

You have to calculate it at database level.

Date1- Date2 * 86400

---

rohit12 (BOB member since 2008-11-08)

[system]

This topic may help:

Diff between two dates

I am trying to create a variable in Desktop Intelligence XI that will give me the diff between two dates. I used “=DaysBetween(<Admit Date & Time> ,<Order Date & Time>)” and I get just days. Is there a way to get his broke down to hours, minutes and seconds? djohnson (BOB member since 2007-07-26)

---

Marek Chladny (BOB member since 2003-11-27)