Re: help with to_date and to_char

Edmund Bacon wrote:
> When current_date is, say Aug 31 then
>
> select to_char( to_date('05' || '/' || to_char(current_date, 'DD/YYYY'),
> 'MM/DD/YYYY' ), 'MON' );
>

NUTS! that should have been
select ... to_date('02' || ...

{ cut, paste, ?edit? }

> returns 'MAR', which is probably not what you want.
>
> This works with 7.3.2, 7.4.5 and 8.0beta2.
>
--
Edmund Bacon <ebacon(at)onesystem(dot)com>