© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
FilamentF
Filament•2y ago
🤖transistor🤖

Table text column date confusion

Hey everyone.
I don't get it. I have my Users table with the column
email_verfied_at
email_verfied_at
of type
timestamptz
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
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'),
Tables\Columns\TextColumn::make('email_verified_at'),


What I'm looking for is
2024-06-05 13:19:49
2024-06-05 13:19:49
which is the correct date/time for Madrid.

If I add
->timezone('Europe/Madrid')
->timezone('Europe/Madrid')
to the text column nothing happens, still the UTC date.

If I add
->dateTime()
->dateTime()
the date is now:
Jun 5, 2024 17:19:49
Jun 5, 2024 17:19:49
which is 4 hours ahead of UTC, not 2 for Madrid, why?

If I add
->timezone('Europe/Madrid')
->timezone('Europe/Madrid')
after dateTime, the date is now:
Jun 5, 2024 19:19:49
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
auth()->user()->timezone

I also know that I can mutate the date in the model, but this should work, right?
Any pointers? Thanks!
Filament banner
FilamentJoin
A powerful open source UI framework for Laravel • Build and ship admin panels & apps fast with Livewire
20,307Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Text area use in table column
FilamentFFilament / ❓┊help
2y ago
Custom query for table column text
FilamentFFilament / ❓┊help
3y ago
Filament Table Text Column action not firing
FilamentFFilament / ❓┊help
16mo ago
Table Builder - TextInput Column - Date Picker as content
FilamentFFilament / ❓┊help
3y ago