This 3 lines will give you the current date minus 1 hour: $date = date("d-m-Y H:i"); $newdate = strtotime ( ‘-1 hour’ , strtotime ( $date ) ) ; $newdateStr = date (‘d-m-Y H:i’ , $newdate );
When you insert or update a date in a mysql Table you have to remember that Mysql have 3 types of date DATETIME ( default format 0000-00-00 00:00:00 ) DATE ( default format 0000-00-00 ) TIMESTAMP ( default format 0000-00-00 00:00:00 ) PHP code: DATE -> $mysqldate = date( ‘Y-m-d’ ); DATETIME, TSTAMP [...]