I am trying to insert date and time into a table, see below:
$date = date(time()); $hours = date('h',$date); $mins = date('m',$date); $secs = date('s',$date); $_POST['date'] = $_POST['year'].'-'. $_POST['month'].'-'.$_POST['day'].' '.$hours.':'.$mins.':'.$secs;
The date is selected by the user via a calendar, it all works fine. But when i check the inserted row it inserts like this:
The date is fine but the time is wrong, it should have added it like this:
I think the time formate may be wrong? I need it to be in UK time format.
Any ideas how i can do this?