Laravel equivalent of sql datetime casting

Question

I have a table which consist of ddate and time_start column and I wanted to compare it to today.

In SQL Server, I can directly cast ddate and timestart to format my desired date and compare it to GETDATE().

In my case, how do I compare the separate (ddate and time_start) to today?

EDITED
What I wanted is to concatenate it like '2020-06-01 11:23:00' and then compare it to today

In that case you can do it exactly like you'd do in normal SQL. Depending on your logic, you might want to use a whereRaw() — shaedrich
– shaedrich, Commented Jun 1, 2021 at 15:59

shaedrich · Accepted Answer · 2021-06-09 10:27:57Z

1

The content of whereRaw() should be similar to what you're doing in plain SQL. If not, feel free to customize it.

DB::table('your_table')
    ->whereRaw('CONCAT(ddate, " ", time_start) = GETDATE()')

edited Jun 9, 2021 at 10:27

answered Jun 1, 2021 at 16:02

shaedrich

5,7633 gold badges31 silver badges47 bronze badges

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

3 Comments

yareyaredaze Over a year ago

Exactly what I'm concerned about if I can directly concat the column. Thanks, man.

yareyaredaze Over a year ago

one last thing tho :), how can I convert time_start which is AM/PM format to 24 hour format. Normally one would use date('H:i:s', strtotime(time_start), but it gives me error.

shaedrich Over a year ago

That's because you're in SQL not PHP. It seems that MySQL can't really parse 12-hour format. Can't you store the time in 24-hour format and only output it in 12-hour format? I bet, that'd make it much easier.

Collectives™ on Stack Overflow

Laravel equivalent of sql datetime casting

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related