2 years 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 "event_id" = '1', "event_name" = 'John Smith Birthday', "event_party_size" = '10', "event_date" = '2024-05-29', "event_start_time" = 'Invalid Date', "event_end_time" = 'Invalid Date', "event_pre_order_deadline" = '2024-05-15', "event_note" = 'Railway DEV db' where "event_id" = '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
2 years 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 2 years ago
2 years ago
Hi Brody, thanks for getting back to me. Thanks for the update. Understood.
Thank you.