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 <[EMAIL PROTECTED]>
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
