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