Hi guys,
I am having ALOT of trouble working out how to convert my timestamp held in the MYSQL DB into the correct format for Australian time.
Can anyone help ?
I am using this to add the current time to the DB:
<input type="hidden" name="date" value="<?php echo date("Y/m/d @ H:i:s"); ?>">
I assume I need to use something like this to extract it:
$date = $row["date"]; // timestamp in DB
putenv("TZ=australia/QLD");
$offset = 3600*10;
???? $newdate = gmdate("dS F Y, G:i", time() + $offset); ????
