Level 1
I'm not sure I understand what you're asking, but maybe this will work for you.
public function scopeUpcoming($query)
{
return $query->whereDate('start_date_time', '>', now());
}
May 11, 2020
5
Level 1
How can I write this eloquent query involving time zones and current datetime?
Hi I can't figure out how to write this scope query using Eloquent in Laravel. This is my latest attempt:
public function scopeUpcoming($query)
{
return $query->where('start_date_time', '>', date('Y-m-d H:i:s'));
}
I have a table called 'Lessons' where the start_date_time is stored as the local timezone. Since Mysql doesn't allow the timezone to be stored in the same date_time column, I have another column in the table calledtime_zone where the relevant time zone is stored.
My goal is to compare start_date_time with the current datetime in the timezone of the lesson... , but currently the query is comparing start_date_time with the current datetime in UTC.
Is there anyway to achieve this without having to store start_date_time in UTC? Thanks for any tips.
Level 1
now() returns the current time in UTC, however 'start_date_time' is stored in the local time zone in my case...
Level 1
is there anyway to change 'start_date_time' to UTC in the query?
Level 33
How about using RAW sql?
Something like:
public function scopeUpcoming($query)
{
return $query->whereRaw('CONVERT_TZ(start_date_time, start_date_time_tz, "UTC") > ?', now());
}
start_date_time_tz would be the column where you're storing the timezone. The function supports numeric timezones such as "'+00:00" and named timezones such as "Europe/Helsinki".
Mind you, the query is untested.
Level 1
thanks, i'll try that
1 like
Please or to participate in this conversation.