Yup, even better. For some reason I gave up trying to_date( '02', 'MON'
), which clearly wasn't working.
Thanks for the improvement!
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260
Edmund Bacon wrote:
When current_date is, say Aug 31 then
select to_char( to_date('05' || '/' || to_char(current_date, 'DD/'),
'MM/DD/' ), 'MON' );
NUTS! that should have been
select ... to_date('02' || ...
{ cut, paste, ?edit? }
returns 'MAR', which is probably not what
Thanks Thomas it worked great ,even when I put in the var - when_month
:)
Lori
Thomas F.O'Connell wrote:
There might be a better way, but this should do what you want. And I
think that you can safely replace '05' with when_month.
select to_char( to_date( '05' || '/' || to_char( current_date,
'DD
Thomas F.O'Connell wrote:
There might be a better way, but this should do what you want. And I
think that you can safely replace '05' with when_month.
select to_char( to_date( '05' || '/' || to_char( current_date, 'DD/'
), 'MM/DD/' ), 'MON' );
Perhaps
select to_char(to_date('02', 'MM')
There might be a better way, but this should do what you want. And I
think that you can safely replace '05' with when_month.
select to_char( to_date( '05' || '/' || to_char( current_date,
'DD/' ), 'MM/DD/' ), 'MON' );
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitenin
Im trying to do something very simple
I have a field called when_month (integer )
so I want to get the month name for the integer
this comes close to what I want
update mytable set myfield=to_char(current_timestamp,'MON');
the result is myfield is set to OCT
which is close to what I want but when I
