Re: MySQL -> PostgreSQL conversion issue

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(at)solfertje(dot)student(dot)utwente(dot)nl> 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!
>
>
>