From: haries fajar nugroho <hariesfn@gmail.com>
To: pgsql-sql@postgresql.org
Subject: ask about epoch query with datetime
Date: Thu, 7 May 2009 15:24:22 +0700
Message-ID: <bf3435570905070124t3b97baachd6c6eab41da68c08@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: hariesfn@gmail.com
Subject: Re: ask about epoch query with datetime
In-Reply-To: <bf3435570905070124t3b97baachd6c6eab41da68c08@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox