SELECT to_char( timestamp, 'HH12:MI am') FROM feasts;
or time
from psql prompt gives
Function 'to_char(time, unknown)' does not exist
Unable to identify a function that satisfies the given argument types
you may need to add explicit typecasts
time has the type of time
Any idea?
Tom
> On Fri, 2002-05-10 at 15:30, hodges@xprt.net wrote:
> > I have 3 queries and some php to run them. What I need is
> > to display the time in a HH:MM am format. Doesn't need to
> > be stored that way in the table?
>
> Right, so instead of:
>
> SELECT timestamp_field FROM mytable;
>
> you want:
>
> SELECT to_char( timestamp_field, 'HH12:MI am') FROM mytable;
>
> And for lots more information, look at the docs:
>
> >
> > On 9 May 2002 at 20:55, Larry Rosenman wrote:
> >
> > > look at the to_char function on
> > > http://www.lerctr.org/postgresql/functions-formatting.html
> > >
>
> Regards,
> Andrew.
> --
> --------------------------------------------------------------------
> Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
> WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St
> DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267
> Are you enrolled at http://schoolreunions.co.nz/ yet?
>
