CODEWITHSUNDEEP
datetimecoldfusiondiffdatediff
AnApprentice
AnApprentice

Reputation: 111030

Coldfusion, Compare two TimeStamp to get the difference in Hours

I'm going have SELECT a TIMESTAMP from the MySQL database. What I want to do is compare that to the current time using ColdFusion.

If 1+ from the DIFF do this.... If LT 1hr do this....

Thanks

Upvotes: 1

Views: 5867

Answers (1)

Henry
Henry

Reputation: 32915

Use DateDiff() in ColdFusion

DateDiff("h", yourQuery.date, now())

Upvotes: 7

Related Questions