Unexpected data found date format?

Question

There istimestamp field (not null) in UTC in database with value: 2019-08-09 20:06:08.

I tried to convert this time to local time using function:

private function toLocalTime($dateInUTC) {
        $time = strtotime($dateInUTC.' UTC');
        return date("d/m/Y H:i", $time);
}

Converting is:

$response = []; // Data is present here
foreach($response as $v) {
   $v->created_at = $this->toLocalTime($v->created_at);
}

On line where I call $this->toLocalTime() I get exception:

I have tried this code:

$timestamp = '2019-08-09 10:41:00';
$date = Carbon::createFromFormat('Y-m-d H:i:s', $timestamp, 'UTC');
$date->setTimezone('your/timezone'); // 
$new_date = $date->format('your new format'); // Y-m-d H:i:s

Maybe my $timestamp is empty somewhere?

So you are setting `$response` to an empty array and then looping over it? — ehymel, Aug 08 '19 at 22:33
What function is throwing the _Unexpected data found_ error? It looks like you've got a trace right there. — Halcyon, Aug 08 '19 at 22:38
the response `array` is empty. BTW, using `gmdate("d/m/Y H:i", strtotime($v->created_at))` would give you the `UTC` time directly, see [gmdate](https://www.php.net/manual/fr/function.gmdate.php) on `php.net` docs. — ThS, Aug 08 '19 at 22:40

Ezequiel Fernandez · Accepted Answer · 2019-08-08T23:12:38.743

1

As I can see you have Carbon in your project:

$timestamp = '2019-08-09 10:41:00';
$date = Carbon::createFromFormat('Y-m-d H:i:s', $timestamp, 'UTC');

$date->setTimezone('America/Argentina/Buenos_Aires'); // or your timezone
$new_date = $date->format('Y-m-d H:i:s'); // or your new format

in your example:

private function toLocalTime($dateInUTC) 
{
    // parse your date with carbon and set that as UTC
    $date = Carbon::createFromFormat('Y-m-d H:i:s', $dateInUTC, 'UTC');
    // set your timezone to get a local time.
    $date->setTimezone('America/Argentina/Buenos_Aires'); // or your timezone
    return = $date->format('Y-m-d H:i:s'); // or your new format
}

https://www.php.net/manual/en/timezones.php

If you don't have Carbon installed as your example using native php:

private function toLocalTime($dateInUTC) 
{

    $utc_date = \DateTime::createFromFormat('Y-m-d H:i:s', $dateInUTC), new DateTimeZone('UTC'));

    $utc_date->setTimeZone(new \DateTimeZone('America/Argentina/Buenos_Aires'); // or your timezone

    return $utc_date->format('Y-m-d H:i:s'); // or your new format
}

edited Aug 08 '19 at 23:12

answered Aug 08 '19 at 22:40

Ezequiel Fernandez

954
11
18

Have you updated your timezone? https://www.php.net/manual/en/timezones.php . For example: 'America/Argentina/Buenos_Aires' – Ezequiel Fernandez Aug 08 '19 at 22:53
I have Carbon installed – POV Aug 08 '19 at 22:55
Perhaps problem in Laravel model sugar free created_at field? – POV Aug 08 '19 at 22:59
Yes, but you need to get your time zone to define it. where are you? – Ezequiel Fernandez Aug 08 '19 at 22:59
Lets assume that I have Carbon date not string date, how to set timezone for that ? – POV Aug 08 '19 at 23:03
You have in your database datetime in UTC right? See the second part in my example! – Ezequiel Fernandez Aug 08 '19 at 23:06
Something is wrong with line: `DateTime::createFromFormat('Y-m-d H:i:s', $dateInUTC), new DateTimeZone('UTC'));` – POV Aug 08 '19 at 23:09
Class 'App\Exports\DateTime' not found" – POV Aug 08 '19 at 23:10
Call to a member function setTimeZone() on bool – POV Aug 08 '19 at 23:10
I have updated that. but you have Carbon already installed, Use it! Use my second exmaple, the Carbon one. – Ezequiel Fernandez Aug 08 '19 at 23:13
private function toLocalTime($dateInUTC) { // parse your date with carbon and set that as UTC $date = Carbon::createFromFormat('Y-m-d H:i:s', $dateInUTC, 'UTC'); // set your timezone to get a local time. $date->setTimezone('America/Argentina/Buenos_Aires'); // or your timezone return = $date->format('Y-m-d H:i:s'); // or your new format } – Ezequiel Fernandez Aug 08 '19 at 23:13
I used this, it give error: `exception: "InvalidArgumentException" file: "C:\Dev\ch-guestsreg-backend\vendor\nesbot\carbon\src\Carbon\Carbon.php" line: 917 message: "Data missing"` – POV Aug 08 '19 at 23:15
mmm in that case your datetime data is not good. make sure your datetime is correct with format "Y-m-d H:i:s" – Ezequiel Fernandez Aug 08 '19 at 23:18

Unexpected data found date format?

1 Answers1