Re: MySQL -> PostgreSQL conversion issue

[DM <dm.aeqa@xxxxxxxxx>]

Thank you for your reply, sorry for the late response, your reply really helped me.

Thanks

Deepak

On Fri, Aug 19, 2011 at 11:39 AM, Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

On 19 Aug 2011, at 14:50, 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?

I think you want something like this?:

development=> select '1970-01-02 00:00:00'::timestamp without time zone - '1970-01-01 00:00:00'::timestamp without time zone;
 ?column?
 ----------
 1 day(1 row)

Midnight 1970-01-01 being the baseline for their calculations is a bit of a guess, but that seems to make sense with the example you gave.
You probably don't want postgres to be smart with your client's time zone settings, hence the "without time zone".

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:1293,4e4eadd212091422813852!