I have created a table in retool database and it contains two Date+Time fields with PostgreSQL type of TIMESTAMP. I added a form component onto main and used the Generate form function to create a form. The fields in question where configured as time components. I fill the form an when I submit the…

Invalid input syntax for type timestamp

Tess May 1, 2023, 10:28pm 3

I have seen something similar with null values, which can require a bit more manual configuration

Topic		Replies	Views
Invalid input syntax for type timestamp with time zone: "" 💬 App Building	3	3929	February 26, 2024
Trouble sending created_at timestamps from Retool form to BigQuery 💬 App Building sql	4	123	July 25, 2025
Invalid input syntax for type date: "" 💬 App Building	11	484	April 14, 2025
Date fields being automatically converted to Datetime strings 💬 Queries and Resources	8	1860	February 13, 2024
Problem saving empty date fields to Retool DB 💬 App Building date , date-time	3	3219	July 27, 2023