On Fri, Dec 10, 2010 at 12:33 PM, Thomas Kellerer <spam_ea...@gmx.net> wrote: >> And I'm not sure how to copy the Oracle's strange DATE >> column best into PostgreSQL, without losing precision? > > Oracle's DATE includes a time part as well. > > So simply use a timestamp in PostgreSQL and everything should be fine.
Yes, but how can I copy Oracle's DATE into PostgreSQL's timestamp? (I realize that this more an Oracle question, sorry) What format string should I take for Oracle's to_date() function, I don't see a format string to get epoch seconds there Regards Alex -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
