Re: No such function 'to_char' with the specified attributes

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: "Yadira M(dot) Rodriguez" <ymrodriguez(at)omeninc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: No such function 'to_char' with the specified attributes
Date: 2000-07-06 12:56:10
Message-ID: Pine.LNX.3.96.1000706145412.14481A-100000@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 5 Jul 2000, Yadira M. Rodriguez wrote:

> Hi,
>
> I'm getting this error: "No such function 'to_char' with the specified
> attributes" when trying to select a timestamp type field. For example:
> "select to_char(col_name, 'MM-DD-YYYY') from table_name". Is there
> somebody that can help me with this?
>

How PG version you use? The to_char() is available in 7.0 (or later) only.

Karel

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mike Field 2000-07-06 13:42:02 Postmaster crashes
Previous Message rob 2000-07-05 22:53:40 type oidvector undefined??