a year ago
I am using the Postgres database, I have two columns that takes a time input, event start time and event end time. Instead of the times displaying in the columns, it displays invalid date instead.
I checked the logs and saw the following error message:
2024-05-15 20:16:05.794 UTC [451] ERROR: invalid input syntax for type time: "Invalid Date" at character 163
level:
"error"
replica: faf11c89-ab0c-4dd2-bcac-163db0070971
2024-05-15 20:16:05.794 UTC [451] STATEMENT: update "public"."events" set "eventid" = '1', "eventname" = 'John Smith Birthday', "eventpartysize" = '10', "eventdate" = '2024-05-29', "eventstarttime" = 'Invalid Date', "eventendtime" = 'Invalid Date', "eventpreorderdeadline" = '2024-05-15', "eventnote" = 'Railway DEV db' where "eventid" = '1'
I have pg admin, when I check the tables, the times displays correctly as expected
I'm on the trail version of railway, I wanted to test it before committing
Any help will be apricated, Thank you.
2 Replies
a year ago
Please do not use the data tab as it's full of bugs, if you are familiar with pgadmin continue using only that.
Status changed to Solved Railway • about 1 year ago
a year ago
Hi Brody, thanks for getting back to me. Thanks for the update. Understood.
Thank you.