Re: to_char with time

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

-Aaron

On 6/13/06, chester c young <chestercyoung@yahoo.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