How to check if the date is greater than today's date Laravel5

Question

I have a table where there is a column which has event date

but the column is of type varchar.

The date is saved in form of dd-mm-yy

now I want to get all the events whose date is greater than today's date.

My code which doesnot work looks like this

$cat=Event::where('date','>=',date('d-m-Y'))->get();

But its not working it is getting me all the events

Any help would be appreciated

Thanks

[This](http://stackoverflow.com/questions/28109179/getting-current-date-time-day-in-laravel) should help you i think. — KuKeC, Dec 02 '15 at 13:45
@CBroe I know bro I am updating some one else's designed website , — Vikram Anand Bhushan, Dec 03 '15 at 06:11

alberto-bottarini · Answer 1 · 2015-12-04T08:25:59.327

1

If your columntype is date, you could use Carbon:

use \DateTimeZone;
use Carbon\Carbon;
use App\BlogVideo;

$today = Carbon::now(new DateTimeZone('Europe/Rome'));
Event::where('date','>=',$today)->get();

edited Dec 04 '15 at 08:25

answered Dec 02 '15 at 14:10

alberto-bottarini

1,213
9
21

just checked with this values it not working :) ('01-01-2015' > '01-02-2014') it return false; – Amir Bar Dec 03 '15 at 13:35
I'm using in production environment and it works. I don't know what to say :) – alberto-bottarini Dec 03 '15 at 16:23
are you sure you date is varchar? there is no doubt no matter what programing languages that '01-01-2015' is not bigger than '01-02-2014', – Amir Bar Dec 03 '15 at 18:49
Ops, you are right, I forget about varchar column type :) Fix the answer. – alberto-bottarini Dec 04 '15 at 08:24

score 0 · Answer 2 · answered Dec 02 '15 at 15:43

0

If column is varchar type there is nothing you can do, except change the column datatype to date or datetime. Then, just do what you did before:

Event::where('date','>=', new \DateTime('now'))->get();

answered Dec 02 '15 at 15:43

manix

14,537
11
70
107

How to check if the date is greater than today's date Laravel5

2 Answers2