MySQL -> PostgreSQL conversion issue

From: DM <dm(dot)aeqa(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: MySQL -> PostgreSQL conversion issue
Date: 2011-08-19 12:50:58
Message-ID: CAO0A+LhfjAhDVu8BGLnE4ajoF3yFWuhKLVsSUXHB_j_2qH70fA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message c k 2011-08-19 13:34:36 Re: Syncing Data to Production DB Server
Previous Message Alexander Perepelica 2011-08-19 12:40:44 Re: synchronous_standby_names with '*'