PHP and MySQL syntax: Difference between revisions

PHP and MySQL syntax (edit)

165 bytes added , 17 February 2016

14,983

edits

@@ Line 88: / Line 88: @@
 === time difference of two time values ===
-* php: using mktime() function
+* php: using [http://php.net/manual/en/function.mktime.php mktime()] function
-* mysql: SELECT TIMEDIFF('2010:01:01 00:00:00', '2010:02:01 00:00:00'); /* return -744:00:00 */
+* mysql: using  [http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_timediff TIMEDIFF()] function ex: SELECT TIMEDIFF('2016:02:01 00:00:00', '2016:01:01 00:00:00'); /* return 744:00:00 */
 === date interval ===