I have any invalid date error in my event time column on by database table

ameuseme
HOBBY

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.

Solved

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


ameuseme
HOBBY

a year ago

Hi Brody, thanks for getting back to me. Thanks for the update. Understood.
Thank you.


I have any invalid date error in my event time column on by database table - Railway Help Station