innstory

PHP的日期加減運算

Temperature: 0 °C

2012-02-28 Chung

在2004-01-08再加上15天 = 2004-01-23

$years = date("Y"); //用date()函式取得目前年份格式0000

$months = date("m"); //用date()函式取得目前月份格式00

$days = date("d"); //用date()函式取得目前日期格式00

$day = date("Y-m-d",mktime(0,0,0,$months,$days+15,$years));

$years = date("Y"); //用date()函式取得目前年份格式0000

$months = date("m"); //用date()函式取得目前月份格式00

$days = date("d"); //用date()函式取得目前日期格式00

$day = date("Y-m-d",mktime(0,0,0,$months+6,$days,$years));

$years = date("Y"); //用date()函式取得目前年份格式0000

$months = date("m"); //用date()函式取得目前月份格式00

$days = date("d"); //用date()函式取得目前日期格式00

$day = date("Y-m-d",mktime(0,0,0,$months,$days,$years+2));

$years = date("Y"); //用date()函式取得目前年份格式0000

$months = date("m"); //用date()函式取得目前月份格式00

$days = date("d"); //用date()函式取得目前日期格式00

$day = date("Y-m-d",mktime(0,0,0,$months,$days-15,$years));

$years = date("Y"); //用date()函式取得目前年份格式0000

$months = date("m"); //用date()函式取得目前月份格式00

$days = date("d"); //用date()函式取得目前日期格式00

$day = date("Y-m-d",mktime(0,0,0,$months-6,$days,$years));

$years = date("Y"); //用date()函式取得目前年份格式0000

$months = date("m"); //用date()函式取得目前月份格式00

$days = date("d"); //用date()函式取得目前日期格式00

$day = date("Y-m-d",mktime(0,0,0,$months,$days,$years-2));

select *

FROM commercial

WHERE up_Date = NOW()