DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=GaU14S+gwQvc9azjrSWcricFinfcjK8YMsTEflO/H6tng6alrXt+NVyezmiOxKsPlg
	7xD8qPAJOrn19gD9gg19srOFb14R/QUzTEWchaF0HTfp6t3D/clivm4RWwA1ArkccW8h
	MnofpYAehdmAGQSY9G095sWwGcZU7MNDHQZCs=
MIME-Version: 1.0
In-Reply-To: <bf3435570905070124t3b97baachd6c6eab41da68c08@mail.gmail.com>
References: <bf3435570905070124t3b97baachd6c6eab41da68c08@mail.gmail.com>
Date: Thu, 7 May 2009 17:47:03 +0900
Message-ID: <1d581afe0905070147x7a1fd526k75eb6bb683cf930d@mail.gmail.com>
Subject: Re: ask about epoch query with datetime
From: Ian Barwick <barwick@gmail.com>
To: haries fajar nugroho <hariesfn@gmail.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

2009/5/7 haries fajar nugroho <hariesfn@gmail.com>:
> 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: =C2=A0function datetime("unknown") does not exist
> HINT: =C2=A0No function matches the given name and argument types. You ma=
y
> need to add explicit type casts.
>
> If i read the error message, it means the function has changed or
> something. May =C2=A0I know the latest function so my query can run well =
in
> my PostgreSQL 8.1.11 ?

Try something like:

select date_part('epoch','2009-04-20 17:08:01'::TIMESTAMP -
'2009-04-20 17:04:24'::TIMESTAMP)::int;


Ian Barwick