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

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.

Solved

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


ameuseme
HOBBYOP

2 years ago

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

Thank you.


Welcome!

Sign in to your Railway account to join the conversation.

Loading...