Datediff (MySQL)

[rmatthew]

I an SQL statement that will find the difference in seconds between two different timedate fields.

I am stuck with using MySQL and have noticed that the datediff function doesnt seem to work

Thanks in advance

 

[lebb]

I believe you can just subtract the two dates in question, then convert the result to seconds. DateDiff will only work in Access queries; it is not standard SQL.