© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
2 replies
alx90

update_at timestamp?! How To?

Hey guys, I have a column which have the type timestampz.
I try to fill the field like:
payload.updated_at = new Date()
//OR
payload.updated_at = new Date().toISOString()
//both is not working
payload.updated_at = new Date()
//OR
payload.updated_at = new Date().toISOString()
//both is not working


Im getting the following error:
{
  code: '22007',
  details: null,
  hint: null,
  message: 'invalid input syntax for type timestamp with time zone: "6. September 2022, 17:21"'
}
{
  code: '22007',
  details: null,
  hint: null,
  message: 'invalid input syntax for type timestamp with time zone: "6. September 2022, 17:21"'
}
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

How to update the updated_at field automatically
SupabaseSSupabase / help-and-questions
5mo ago
Automatically update updated_at timestampz
SupabaseSSupabase / help-and-questions
3y ago
How to update column in row on update trigger?
SupabaseSSupabase / help-and-questions
4y ago
How to update pg_graphql extension?
SupabaseSSupabase / help-and-questions
7mo ago