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 of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
