webguync Posted May 20, 2010 Share Posted May 20, 2010 I have two tables with two fields, both timestamps. I need to set up a Query to subtract the difference in minutes between the two fields (login_timestamp and submit_timestamp). login_timestamp is in a table called 'Candidates' and submit_timestamp is in a table called 'Responses'. I believe I would need to use. SELECT TIMESTAMPDIFF(MINUTE,'2010-05-17 12:26:13','2010-05-17 11:32:45'); but a little unsure about how to from two different tables. Thanks in advance! Link to comment https://forums.phpfreaks.com/topic/202422-need-help-with-query-to-determine-timestamp-difference-between-two-fields/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.