I really want a simple function where I give it a certain time and date (in a timezone) and tell it what timezone I want it in - and it should give me the exact date and time in the target zone! Yes of course this is possible internally, but I fear getting it wrong!
Then you need to test, test and test more. If you're outsourcing because you're afraid of programming you should just buy some software. ;P
The function itself is simple enough.
http://php.net/manual/en/datetime.settimezone.php
function convertTimeZone($time, $origin, $target) {
$date = new DateTime($time, new DateTimeZone($origin));
$date->setTimezone(new DateTimeZone($target));
return $date->format('Y-m-d H:i:s');
}
echo convertTimeZone('2000-01-01 00:00:00', 'Pacific/Nauru', 'Pacific/Chatham');