Re: to_char with time

From: "Aaron Bono" <postgresql(at)aranya(dot)com>
To: "chester c young" <chestercyoung(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: to_char with time
Date: 2006-06-14 04:27:12
Message-ID: bf05e51c0606132127ra93b6ecv96f7085f977c5b2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Try select to_char(now(),'HH24:MI');

-Aaron

On 6/13/06, chester c young <chestercyoung(at)yahoo(dot)com> wrote:
> this does not work: select to_char(current_time,'HH24:MI')
>
> what am I missing? is it possible to format a time column in a select?
>
> thanks,
> stumped, aka, chester

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Phillip Smith 2006-06-14 04:27:41 Re: to_char with time
Previous Message chester c young 2006-06-14 04:09:34 to_char with time