CODE EXAMPLE FOR SQL

select only the month-day from date in PL-SQL

select ltrim(TO_CHAR(TO_DATE(sold_dt,'dd/mm/yyyy'),'mm-dd'),'0') as sales_day