Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250])
	by postgresql.org (Postfix) with ESMTP id 05950475B5F
	for <pgsql-sql@postgresql.org>; Wed, 10 Jul 2002 01:46:51 -0400 (EDT)
Received: from [63.195.55.98] (account <josh@agliodbs.com>)
	by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.5.9)
	with HTTP id 1571826; Tue, 09 Jul 2002 22:46:49 -0700
From: "Josh Berkus" <josh@agliodbs.com>
Subject: Re: is there a way to get hh:mm:ss given seconds
To: <narendraa@subexgroup.com>
Cc: pgsql-sql@postgresql.org
X-Mailer: CommuniGate Pro Web Mailer v.3.5.9
Date: Tue, 09 Jul 2002 22:46:49 -0700
Message-ID: <web-1571826@davinci.ethosmedia.com>
In-Reply-To: <000001c227c7$80d8eb30$19ba10ac@narendraa>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200207/126
X-Sequence-Number: 8505

Narendra,

> I tried all these. This is what I get
> SQL> SELECT "interval"(cast(422 as varchar) || ' seconds');
> SELECT "interval"(cast(422 as varchar) || ' seconds')
>                                      *
> ERROR at line 1:
> ORA-00906: missing left parenthesis

> SQL> select '422 seconds'::interval;
> select '422 seconds'::interval
>                     *
> ERROR at line 1:
> ORA-00923: FROM keyword not found where expected

Those don't look like PostgreSQL error messages.  I think you are using
some other database.

-Josh Berkus