月初．月底

MS-SQL

select GETDATE() today,

convert(datetime,convert(char(8), YEAR(getdate()) * 10000 + MONTH(getdate()) * 100 + '01', 112)) month_start,

convert(char(6),dateadd(month,1,getdate()),112)+'01' next_month,

dateadd(day, -1, convert(datetime,(convert(char(6),dateadd(month,1,getdate()),112)+'01'))) month_end

Oracle

select * from OPENQUERY(ORACLE_PROD,'

select to_date(to_char(sysdate,''yyyymm'') || ''01'', ''yyyymmdd'') month_start,

trunc(last_day(sysdate)) month_end

from dual

')

--
備忘一下


--