oracle中怎么查詢一年中每個月的第一天?
select last_day(add_months(to_date(concat(to_char(sysdate,'yyyy'),'1231'),'yyyy-mm-dd'),-level))+1 dates from dual connect by level
oracle中怎么查詢一年中每個月的第一天?
select last_day(add_months(to_date(concat(to_char(sysdate,'yyyy'),'1231'),'yyyy-mm-dd'),-level))+1 dates from dual connect by level