How do you put a time in a Postgres database?
Hello, I need help to be able to put a time in a column of a table in postgres, it appears as invalid date
29 Replies
Project ID:
2d6389fb-0789-40df-b305-240ed5a8129a2d6389fb-0789-40df-b305-240ed5a8129a
what data type are you using for your column?
TIME
Is that data type okay?
probably, it does exist
but I put for example 7:00 and it shows invalid date
I think a regular
timestamp might be easier to work with thoughPostgreSQL Documentation
8.5. Date/Time Types
8.5. Date/Time Types # 8.5.1. Date/Time Input 8.5.2. Date/Time Output 8.5.3. Time Zones 8.5.4. Interval Input 8.5.5. Interval Output PostgreSQL supports …
thanks
I see it now
I think for TIME you might have to specify
HH:MM:SS at a minimum for it to be valid
or maybe HH:MM is enoughI already tried and nothing, I have entered 7:00:00, 7:00, 7:00 UTC and invalid date appears
will this be?
But what does the p mean or how does i can put in the table?
Im new with postgres
where are you inputting this data into your database
in a time table with a column of type TIME
yes but what software are you using
software?
im using railway
in web
the data tab is only meant to give you a general overview of your data, do not use it for data entry
ohh, and how can I do it?
I'm doing it here
where invalid date is is where I'm trying to put a time
use database software like pgadmin
So I can't add an hour there only if I have pgadmin?
the data tab is only meant to give you a general overview of your data, use pgadmin for data entry
ok, thank you very much, I'm already downloading it
After i download it, just set a time like 7:00 and it would be ready?
yes it will
Here is it the remote access option or the other one?
remote
okey