Re: [SQL] to_char with time

2006-06-13 Thread Phillip Smith
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?

Re: [SQL] to_char with time

2006-06-13 Thread Aaron Bono
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

[SQL] to_char with time

2006-06-13 Thread chester c young
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