So I have a simple form that saves data to a Retool DB. The form contains two "Date Time" and "Date" fields, nothening to fancy. Only one "Date Time" field is required, the other fields are optional. The fields don't have a default value, and use the default formatting. The two "Date Time" fields ha…

Welcome to the forum @Jeff76 I have to dodge this particular pothole quite often. You have to send a null back to the database if the date or time components are not populated. This is the easiest way: [image] I did not give the job_date the same treatment as start_time and end_time as it is a …

Problem saving empty date fields to Retool DB

💬 App Building

Topic		Replies	Views
Revisiting Saving Empty Date Fields to Retool Database 💬 App Building	2	731	November 13, 2023
Invalid input syntax for type timestamp with time zone: "" 💬 App Building	3	3833	February 26, 2024
TIME values of null are converted to empty string which is invalid 💬 Feature Requests bug	2	45	May 8, 2025
Invalid input syntax for type date: "" 💬 App Building	11	392	April 14, 2025
Updating SQL Table With Null Dates 💬 Queries and Resources bug , sql	1	1279	February 12, 2024

Problem saving empty date fields to Retool DB

Related topics