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 form I get this error " invalid input syntax for type timestamp"
Thanks for the feedback! I haven't been able to reproduce this yet. I know you mentioned it's a
timestamp, but would mind sharing the full config for the column on the db side:
The good news is that you can replace the time input with a date time component to the form & you won't need to do anything to the insert query, as it just references the full form:
I have seen something similar with null values, which can require a bit more manual configuration
I'm having a similar problem but my varient is when exporting and importing csvs from retool db.
I recently got access to a staging environment, so I'm trying to take my production data and export it into staging. I know this is backwards, but it's a consequence of upgrading my retool plan.
Create a table with column of type timestamp.
Insert a record.
Export the csv
Import the same csv into the table
Thanks for reaching out! We have a bug where this error can happen with any records that have an empty cell or null value - even if you've set up your column to be nullable Any chance that's what you're running into?
Just noting that the bug mentioned above has been fixed