Peter Koukoulis <pkoukou...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
