Invalid input syntax for type timestamp

Queries and Resources
1

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"

2

Hi @Yiannis_Kapodistrias

Thanks for the feedback! :thinking: 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:

3

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

4

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.

Repro steps:
Create a table with column of type timestamp.
Insert a record.
Export the csv
Import the same csv into the table

image

5

Hi @bithippie

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 :disappointed: Any chance that's what you're running into?

6
7

Just noting that the bug mentioned above has been fixed :slightly_smiling_face: