Table text column date confusion
Hey everyone.
I don't get it. I have my Users table with the column
My app timezone config is set to UTC.
An example date is
In a table, when I make a simple text column, the date is displayed in UTC as expected.
What I'm looking for is
If I add
If I add
If I add
I have to keep the timezone dynamic, because it would depend on the timezone the user has selected, not a problem, I know I can get it via
I also know that I can mutate the date in the model, but this should work, right?
Any pointers? Thanks!
I don't get it. I have my Users table with the column
email_verfied_at of type timestamptz and the date is saved in UTC.My app timezone config is set to UTC.
An example date is
2024-06-05 11:19:49-06 in UTC.In a table, when I make a simple text column, the date is displayed in UTC as expected.
Tables\Columns\TextColumn::make('email_verified_at'),What I'm looking for is
2024-06-05 13:19:49 which is the correct date/time for Madrid.If I add
->timezone('Europe/Madrid') to the text column nothing happens, still the UTC date.If I add
->dateTime() the date is now: Jun 5, 2024 17:19:49 which is 4 hours ahead of UTC, not 2 for Madrid, why?If I add
->timezone('Europe/Madrid') after dateTime, the date is now: Jun 5, 2024 19:19:49, now 4 hours ahead of Madrid, why?I have to keep the timezone dynamic, because it would depend on the timezone the user has selected, not a problem, I know I can get it via
auth()->user()->timezone I also know that I can mutate the date in the model, but this should work, right?
Any pointers? Thanks!
