chester
c young
Sent: Wednesday,
14 June 2006 2:10
PM
To: pgsql-sql@postgresql.org
Subject: [SQL] to_char with time
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?
Try select to_char(now(),'HH24:MI');
-Aaron
On 6/13/06, chester c young <[EMAIL PROTECTED]> 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
---(end
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.y