Getting only time from Carbon object

user_3541320 0
Viewed 21030

Im reading an excel file a column with values like "1:45:00. But when print_r($value["time"]) this value from my array I got a Carbon object like this:

Carbon\Carbon Object
(
    [date] => 2018-10-30 01:45:00.000000
    [timezone_type] => 3
    [timezone] => America/US
)

Then, when I insert to a bulk array my value with:

"time"=>$value["time"]

In the database I got: 2018-10-30 01:45:00

How can I insert only 01:45:00 and not the entire timestamp?

EDIT: I thought that $value["time"]->date->format("H:i:s") would works but I got the error "Trying to get property 'date' of non-object"

EDIT 2: This is how I read the data:

The excel is like:

date         time
----------   -------
30-10-2018   01:45:00

The code where I read the excel:

$data = Excel::selectSheetsByIndex(0)->load($path, function($reader) {
})->get()->toArray();

foreach ($data as $key => $value) {
    $time = Carbon::createFromFormat('Y-m-d h:i:s',$value["time"])->format('h:i:s');
    print_r($time);
    die();
}

The output:

Call to a member function format() on null

php-carbon laravel php
2 Answers

What you need is the formatting here:

$dt = Carbon::now();
$dt->toTimeString(); //14:15:16
user_31595290

Carbon\Carbon is an extension to php's DateTime, so you can read at php.net to learn more.

Although America/US is not a valid timezone, so there's something going on with that.

Anyway,

In the database I got: 2018-10-30 01:45:00

If your data type is a TIMESTAMP or a DATETIME, mysql will always have a date component for data in that column.

First, let's get the time out of the $value array to make the rest of the discussion easier to understand and debug:

$time = $value["time"];

From here on out, pay no attention to the internal fields revealed by var_dump. They may or may not actually exist like that in the object. Use the mostly-well-documented interface methods documented in the link above or in the Carbon docs. The fields given by var_dump will just confuse you otherwise.

If you just want the time of day represented as a string, you use the DateTime::format() method:

$timestr = $time->format('H:i:s');

Note that if you insert that string in a database with a DATETIME column type, it won't work. Mysql will require a string that includes date information.

The code snippet that follows doesn't seem to match with the code you show above:

$data = Excel::selectSheetsByIndex(0)->load($path, function($reader) {
})->get()->toArray();

foreach ($data as $key => $value) {
    $time = Carbon::createFromFormat('Y-m-d h:i:s',$value["time"])->format('h:i:s');
    print_r($time);
}

You are trying to create a Carbon instance using the createFromFormat() method. The first parameter you provide tells Carbon (actually DateTime) what the format of your input string will be. The data you are supplying is H:i:s (assuming $value["time"] is read from the time column of your Excel sheet), but you're telling Carbon that you will be giving it Y-m-d h:i:s. Since the format you promise doesn't match the data you are giving the object, null is resulting.

Either (broken into to steps for clarity):

$time = Carbon::createFromFormat('H:i:s', $value["time"]);
$timestr = $time->format('h:i:s');

or

$time = Carbon::createFromFormat('d-m-Y H:i:s', $value["date"] . " " . $value["time"]);
$timestr = $time->format('h:i:s');

will work.

The second one gives you a Carbon object that is much more useful - the first one will probably default to year zero. In both cases the timezone will be the zone of the machine the code is running on. You can override that if necessary.

Note that if I'm confused and the Excel reader is actually returning Cabon objects rather than strings, you can eliminate the whole createFromFormat code altogether. No sense making a Carbon object out of a Carbon object.

user_4917540
Related