Hey Thomas, Alexander 2010/12/10 Thomas Kellerer <spam_ea...@gmx.net>
> Alexander Farber, 10.12.2010 12:53: > > 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 >> > > I have no idea what you are doing in PHP, but why don't you simply generate > a valid date/time literal for Postgres using the to_char() function? > > Something like > > SELECT 'TIMESTAMP '''||to_char(QDATETIME, 'YYYY-MM-DD HH24:MI:SS')||'''' > FROM qtrack; > > That literal can directly be used in an INSERT statement for PostgreSQL > He asked exactly that. > > Regards > Thomas > > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- // Dmitriy.
