CODEWITHSUNDEEP
phpmysqllaravel
Anita Intansia Hutagaol
Anita Intansia Hutagaol

Reputation: 131

Select Year only from database php (Laravel)

I have a question, how to select year only from database in laravel? I have in my database:

2015-07-02
2015-07-04
2015-08-06

I just want to select year ('2015')

I want to build in Laravel, my code is:

   $visit_time = DB::table('tr_visit')->join ('tm_child','tr_visit.Child_ID','=','tm_child.Child_ID')
       ->where('tr_visit.Child_ID', 'LIKE', '%' . $childName . '%')
       ->groupBy(DB::raw('YEAR(tr_visit.Visit_Date)'))
       ->groupBy(DB::raw('MONTH(tr_visit.Visit_Date)'))
       ->select(DB::raw('YEAR(Visit_Date)'))->distinct()->get();

Please help me, thank you

Upvotes: 2

Views: 7827

Answers (2)

Daniel Muñoz
Daniel Muñoz

Reputation: 91

you can use 

->selectRaw('YEAR(Visit_Date)')

And using Eloquent

$visit_time = Tr_visit::join('tm_child', 'tr_visit.Child_ID', '=', 'tm_child.Child_ID')
->where('tr_visit.Child_ID', 'like', '%' . $childName . '%')
->groupBy(['date', 'month'])
->selectRaw('YEAR(tr_visit.Visit_Date) as date, MONTH(tr_visit.Visit_Date) as month')
->distinct()->get();

Upvotes: 3

user4621032
user4621032

Reputation: 641

edit 

->select(DB::raw('YEAR(tr_visit.Visit_Date)'))

Upvotes: 0

Related Questions