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 doesn't 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.