ask about epoch query with datetime

From: haries fajar nugroho <hariesfn(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: ask about epoch query with datetime
Date: 2009-05-07 08:24:22
Message-ID: bf3435570905070124t3b97baachd6c6eab41da68c08@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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). The
error message is ERROR: function datetime("unknown") does not exist
HINT: No function matches the given name and argument types. You may
need to add explicit type casts.

If i read the error message, it means the function has changed or
something. May I know the latest function so my query can run well in
my PostgreSQL 8.1.11 ?

Thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ian Barwick 2009-05-07 08:47:03 Re: ask about epoch query with datetime
Previous Message Maximilian Tyrtania 2009-05-07 08:21:41 Distinct oddity