Re: A cronjob for copying a table from Oracle

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: A cronjob for copying a table from Oracle
Date: 2010-12-10 11:53:09
Message-ID: AANLkTik-Z0OWcuqSGrNPdHg6_sJQtXASU1rvwj=LXF99@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Dec 10, 2010 at 12:33 PM, Thomas Kellerer <spam_eater(at)gmx(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2010-12-10 12:14:06 Re: A cronjob for copying a table from Oracle
Previous Message Thomas Kellerer 2010-12-10 11:33:53 Re: A cronjob for copying a table from Oracle