Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Laravel - How to get year property of date

I have a "datetime" field in mysql.

$time = "1900-01-01 00:00:00";

I cant get only year. I tried $time -> year, but its not good.

(Trying to get property of non-object) Maybe i need to convert this string to date?

I hope someone can help me! Thanks so much!

like image 663
ketom Avatar asked Dec 10 '15 13:12

ketom


2 Answers

In Laravel you can use Carbon to parse the date:

$time = "1900-01-01 00:00:00";
$date = new Carbon( $time );   

Once you get the Carbon object, to get the year you can do:

$date->year;

Or:

$date->format('Y');
like image 111
Moppo Avatar answered Oct 12 '22 01:10

Moppo


You can do this in two ways,


1 - Define the date filed in the related model as,

public function getDates()
{
    //define the datetime table column names as below in an array, and you will get the
    //carbon objects for these fields in model objects.

    return array('created_at', 'updated_at', 'date_time_field');
}

then laravel return a carbon object for these columns, so that you can use like $time->year.


2- You can create a carbon object and get the year as in Moppo's answer

Carbon::createFromFormat('Y-m-d H:i:s', $time)->year

First one make so clean for me, you can decide which way suits you.

like image 25
Kalhan.Toress Avatar answered Oct 11 '22 23:10

Kalhan.Toress