thanks. didn't realise they were different. I discovered the difference
when using a MD5 comparison between the 2 databases in a C++ utility.
All values were matching apart from dates.
Cheers
P
On Sun, 27 Aug 2017 at 21:35 Tom Lane wrote:
> Peter Koukoulis writes:
> > I am unsure as to why th
Peter Koukoulis 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 "mmddhh24miss", but cannot get the same for PostgreSQL,
> for example:
Hi
I am unsure as to why the hrs, mins and seconds do not appear for a date
column. I am using PostgreSQL 9.6.3 on Linux.
When performing the exact same queries in Oracle, I get the full date
formatted to "mmddhh24miss", but cannot get the same for PostgreSQL,
for example:
ft_node=# create ta
