Try using current_timestamp instead of current_time.
This works for me in a SELECT:
to_char(current_timestamp + '1 MONTH AGO', 'YYMM') as ‘reference’
Cheers,
-p
-Original Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chester
c young
Sent: Wednesda
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
