Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

Crazylife's avatar

How to convert date with specific timezone when retrieving data?

I want to convert my created_at date, i do something like this but got error

 Model::whereDate(DB::raw("(CONVERT_TZ(created_at, +5:00, +8:00))"), '=>', $start)->whereDate(DB::raw("(CONVERT_TZ(created_at, +5:00, +8:00))"), '<=', $end)......
        

I tried but i gave me error, is there anyway can convert timezone using eloquent model?

0 likes
1 reply

Please or to participate in this conversation.