On 8/19/2011 7:50 AM, DM wrote:
Hi All,how to insert mysql (datetime interval) data to postgrres interval datatype. mysql | test_interval | datetime | YES | | 1970-01-02 00:00:00 | | psql test_interval | interval | any solution for this? thanks Deepak
Well.. What is the interval in mysql? Is that supposed to represent + interval '1970 years' + interval '1 month' + interval '2 days'?
In PG you probably have a few options. One, store it as a date, and use dateAdd() functions. Two, store it as text and set the value's to things like '1 hour', '2 years', '70 years 1 month 2 days 4 hours 20 minutes', etc
The calc like 'select someDate + interval yourNewField' Of course... I have not actually tried any of this :-) -Andy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
