String to Date Object PHP Laravel Carbon

Question

How to make date string to date object in PHP using Carbon?

$minTime = DB::table('order') 
            ->select('order_creation_date', 'restaurant_id')
            ->where('restaurant_id', '=', '70')
            ->orderBy('order_creation_date', 'asc')
            ->first();

            $m = $orderDay -> month;
            $d = $orderDay -> day;
            $y = $orderDay -> year;

    $y = (int)$y;
    $d = (int)$d;
    $m = (int)$m;

    $orderDay = $minTime -> order_creation_date;
    var_dump($orderDay);

Error:

Trying to get property of non-object

Normal Value of string:

string(19) "2016-02-05 14:51:30"

Any ideas how to fix it? I think I need make string to date object. Thank you.

revo · Accepted Answer · 2016-08-01 11:45:14Z

1

Using $dates property in Order model:

protected $dates = ['order_creation_date'];

answered Aug 1, 2016 at 11:45

revo

49k15 gold badges84 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

revo Over a year ago

It returns a Carbon object when dealing with order_creation_date. Read about Carbon. @ArnasPuidokas

revo Over a year ago

It doesn't suck. I just said in colloquial Persian, purposely. @WiktorStribiżew

Huzaib Shafi · Accepted Answer · 2016-08-01 12:01:08Z

0

Your error surely is on line 2

Change the order of the code:

$minTime = DB::table('order') 
        ->select('order_creation_date', 'restaurant_id')
        ->where('restaurant_id', '=', '70')
        ->orderBy('order_creation_date', 'asc')
        ->first();

$orderDay = $minTime -> order_creation_date;

        $m = $orderDay -> month;
        $d = $orderDay -> day;
        $y = $orderDay -> year;

$y = (int)$y;
$d = (int)$d;
$m = (int)$m;


var_dump($orderDay);

or when accessing the dates using DB facade, it probably doesn't return a Carbon Instance. Try ..:

$orderDay = Carbon::createFromFormat("Y-m-d H:i:s",$minTime -> order_creation_date);

Alternatively, you should prefer to use $dates property in your Order Model..

protected $dates = ['order_creation_date'];

edited Aug 1, 2016 at 12:01

answered Aug 1, 2016 at 11:45

Huzaib Shafi

1,13810 silver badges24 bronze badges

5 Comments

Huzaib Shafi Over a year ago

@arnas-puidokas Updated.. Check-Again

Arnas Puidokas Over a year ago

Trailing data in Error

Huzaib Shafi Over a year ago

@arnas-puidokas Please explain the error. More description and line no. etc

Arnas Puidokas Over a year ago

in Carbon.php line 425 at Carbon::createFromFormat('Y-n-j G:i:s', '2016-02-05 14:51:30-8-1 11:53:58', null) in Carbon.php line 368 at Carbon::create('2016-02-05 14:51:30') in DashboardController.php line 77 at DashboardController->getDashboardView()

Huzaib Shafi Over a year ago

@arnas-puidokas Oh.. use the following instruction ... $orderDay = Carbon::createFromFormat("Y-m-d H:i:s",$minTime -> order_creation_date);

Collectives™ on Stack Overflow

String to Date Object PHP Laravel Carbon

2 Answers 2

2 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related