mysql 獲取上個(gè)月,這個(gè)月的第一天或最后一天
[導(dǎo)讀]select?date_sub(now(),interval?1?month)????上個(gè)月今天的當(dāng)前時(shí)間
select?UNIX_TIMESTAMP(date_sub(now(),interval?
select?date_sub(now(),interval?1?month)????上個(gè)月今天的當(dāng)前時(shí)間 select?UNIX_TIMESTAMP(date_sub(now(),interval?1?month))????上個(gè)月今天的當(dāng)前時(shí)間(時(shí)間戳) select?date_sub(date_sub(date_format(now(),'%y-%m-%d?08:00:00'),interval?extract(?day?from now())-1?day),interval?1?month)上個(gè)月的第一天 select?UNIX_TIMESTAMP(date_sub(date_sub(date_format(now(),'%y-%m-%d?08:00:00'),interval extract(?day?from?now())-1?day),interval?1?month))????上個(gè)月的第一天(時(shí)間戳) ? 上個(gè)月的第一天:? select?date_sub(date_sub(date_format(now(),'%y-%m-%d'),interval?extract(?? ???day?from?now())-1?day),interval?1?month) ? ? 上個(gè)月的最后一天: select?date_sub(date_sub(date_format(now(),'%y-%m-%d'),interval?extract(?? ???day?from?now())?day),interval?0?month)?as?date ? ? 這個(gè)月的第一天: ?select?date_sub(date_sub(date_format(now(),'%y-%m-%d'),interval?extract(?? ???day?from?now())-1?day),interval?0?month) ? ? 這個(gè)月的最后一天: select?date_sub(date_sub(date_format(now(),'%y-%m-%d'),interval?extract(?? ???day?from?now())?day),interval?-1?month)?as?date





