[SOLVED] What to do with timestamp field calculations

This topic is locked

[SOLVED] Â What to do with timestamp field calculations	5/18/2014 2:01:03 PM
PHPRunner General questions
G gagsoft author I have a MySQL table from which I do a select to. Build a custom view. I manage to add the resulting field but it produces this " 20140402061902 " The field contents look like this. 01/04/2014 09:26:00 - 01-04-2014 11:17:31 AM And the field format is timestamp. I would really appreciate it if anyone help me with this. Thanks


	Sergey Kornilov admin 5/19/2014
	Peter, check this example for inspiration: http://stackoverflow.com/questions/4300380/mysql-difference-between-two-timestamps-in-seconds First answer returns the difference in seconds, the second answer shows more output options.

Â What to do with timestamp field calculations