to_char with time

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: to_char with time
Date: 2006-06-14 04:09:34
Message-ID: 20060614040934.1411.qmail@web54313.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Aaron Bono 2006-06-14 04:27:12 Re: to_char with time
Previous Message Tom Lane 2006-06-14 03:27:11 Re: Good examples of calling slony stored procedures