Date in DB difference with result get in Laravel

Question

i have some table and there are column date with value : 2021-07-01 10:00:00

when im fetching that, with ->get() or ->first() or anything of method in laravel to fetch data, i have difference result, look like the value has formated / converted to another timezone, but in laravel config or env , i dont set anything about configuration of timeszone, i has googling but not finding , can somebody tell me about this case, or maybe iam must be set some config to get proper value?

what is your SQL timezone set as

Jaquarh
– Jaquarh

2021-07-24 11:56:01 +00:00
Commented Jul 24, 2021 at 11:56 — Jaquarh
– Jaquarh, Commented Jul 24, 2021 at 11:56

Vahid Marali · Accepted Answer · 2021-07-24 12:11:42Z

1

There are two ways to update your code. 1- open config/app.php and edit

'timezone' => 'UTC',

Here you can add your timezone like

'timezone' => 'Asia/Tokyo',

If you want to manage your timezone from .env file you can use this code

'timezone' => env('APP_TIMEZONE', 'UTC'),

and add the this line in your .env file.

APP_TIMEZONE='Asia/Tokyo'

answered Jul 24, 2021 at 12:11

Vahid Marali

1366 bronze badges

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

1 Comment

ikhbalfuady Over a year ago

not affected, iam still have difference value

Collectives™ on Stack Overflow

Date in DB difference with result get in Laravel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related