I want to convert date form from d/m/Y to Y-m-d with timezone offset. I am able to convert from d/m/Y to Y-m-d with this code:
$date = DateTime::createFromFormat('d/m/Y', $date);
$date = $date->format('Y-m-d');
But I am not sure how to add the timezone offset.
(PHP 5 >= 5.3.0) you actually enter the third parameter
public static DateTime DateTime::createFromFormat(string $format , string $time[, DateTimeZone $timezone])
$date = DateTime::createFromFormat('d/m/Y', $date, new DateTimeZone('Europe/Berlin'));
DateTimeZone Object) was simply ignored. The only way to achieve this was to use the validated answer published by @John Conde I am running PHP 5.6.30
Just use DateTime::setTimeZone():
$date = DateTime::createFromFormat('d/m/Y', $date);
$date->setTimeZone(new DateTimeZone('America/New_York'));
$date = $date->format('Y-m-d');
+2:00 instead of America/New_York? I know you should use timezones and not offsets because of daylight savings etc. but on this environment timezones like America/New_York are not working.
America/New_York is the timezone of the user?
$date in the server's timezone, and then when setTimeZone() is called, it converts it to "America/New_York". In other words, it introduces a time component - $date is no longer at midnight. Might not be a big deal for some, but it was for me!
I tested both the solutions JohnConde and denoise.
with this script:
$format = 'Y-m-d H:i:s';
$datetime_str = '2022-10-28 17:24:00';
$timezone_str = 'Europe/Rome';
$dt_test_denoise = DateTime::createFromFormat($format, $datetime_str,
new DateTimeZone($timezone_str));
echo '$dt_test_denoise:';
echo "<br/>";
var_dump($dt_test_denoise);
echo "<br/>";
echo "<br/>";
$dt_test_JohnConde = DateTime::createFromFormat($format, $datetime_str);
$dt_test_JohnConde->setTimeZone(new DateTimeZone($timezone_str));
echo '$dt_test_JohnConde:';
echo "<br/>";
var_dump($dt_test_JohnConde);
echo "<br/>";
echo "<br/>";
execute this on http://phptester.net/ and you will see the differences.
I think the best is solution denoise!
