날짜 변환

[mysql 쿼리]
date_format(date_sub((date_add(reg_date, interval 1 month)), interval (date_format(date_add(reg_date, interval 1 day),'&d')) day),'%Y/%m/%d')


[php]
if($view[recall_it] >= '2005-12-07')
{
$view[recall_it] = date('Y-m-d', mktime (0,0,0,date("m") + 1 , date("d") - (date("d") +1 ) , date("Y")));
}

[mssql 쿼리]
select convert(varchar(10),dateadd(mm,1,getdate()),112)