Re: [SQL] ask about epoch query with datetime

2009/5/7 haries fajar nugroho : > Hi All, > > my institution wants me to migrate from old postgresql to new > postgresql, but when i test one of the query it failed at query : > select date_part('epoch',datetime('2009-04-20 > 17:08:01')-datetime('2009-04-20 17:04:24'))::int; > that query runs well

[SQL] ask about epoch query with datetime

Hi All, my institution wants me to migrate from old postgresql to new postgresql, but when i test one of the query it failed at query : select date_part('epoch',datetime('2009-04-20 17:08:01')-datetime('2009-04-20 17:04:24'))::int; that query runs well in previous postgresql (PostgreSQL 7.1.3). Th