Peter Koukoulis <pkoukoulis@gmail.com> writes:
> I am unsure as to why the hrs, mins and seconds do not appear for a date
> column.
Uh, because it's a date.
> When performing the exact same queries in Oracle, I get the full date
> formatted to "yyyymmddhh24miss", but cannot get the same for PostgreSQL,
> for example:
Oracle has a nonstandard notion of what "date" means, I believe. You
probably want to use type "timestamp", and the to_timestamp() function,
in PG if you want behavior similar to what Oracle is doing.
https://www.postgresql.org/docs/current/static/datatype-datetime.html
regards, tom lane