I am inserting the below values into a column with a "date" datatype.
2021-09-20 06:19:00
2021-09-20 12:22:00
The related file is a CSV and inserts successfully using the copy command.
When I select against the column from "dbeaver" the output reflects:
2021-09-20
2021-09-20
The time is missing.
Is the time there really, but there is some format mask I need to use to display it or, am I using the wrong datatype and the value is truncated at insert?