這題目好像有點太簡單! 因為我喜歡用日期的運算處理,所以以mysql為例: 我會用 select * from table_name where (curdat...
SELECT * FROM [資料表] WHERE CURRENT_DATE() BETWEEN [開始日期] AND [結束日期] CURRENT_DATE(...
SELECT * FROM [資料表] WHERE CURRENT_DATE() BETWEEN [開始日期] AND [結束日期] CURRENT_DATE(...