Fetch difference between two timestamps in seconds
Posted: Wed Feb 14, 2007 4:08 pm
Hello
I have a database table where each record has a timestamp (created using the NOW() function perhaps CURRENT_TIMESTAMP is more correct to use?)
I wish to make a simple query which compare timestamp of right now with the timestamp in the database and returns the difference in seconds.
Is there some easy way to do this?
Darla
I have a database table where each record has a timestamp (created using the NOW() function perhaps CURRENT_TIMESTAMP is more correct to use?)
I wish to make a simple query which compare timestamp of right now with the timestamp in the database and returns the difference in seconds.
Is there some easy way to do this?
Darla