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 < dal...@solfertje.student.utwente.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! > > >
