PostgreSQL urgent help.

Question

Is there anyone who know how to deal with date and time in postgresql, am find it really hard uploading my dataset..

Answer 1

https://www.postgresql.org/docs/current/functions-datetime.html

Answer 2

If you give more detail about your specific problem, maybe I can help.
Do you have trouble with insert statements when adding data to a date or time column?

Answer 3

By "more detail", I meant:
- what is your table structure, including data types
- what is the data you are trying to load (at least a sample row)
- in what format is your data and how are you trying to "upload" it
- what is the exact error message you are getting

Without this info, this would be just divination.

Answer 4

I have the dataset on my computer, and have created a table with number of column name, but once i upload the dataset it return error specify it thr date.

Answer 5

Thanks.. still don’t understand it

Answer 6

Thanks bro, are you on telegram so that we can chat better and upload the screenshot of the error message..

Answer 7

This is the error message am getting.