①
SELECT IF(days = 1," yes "," no ")作為"是否是星期天" from (select星期幾(from _ unix time (time," %y-%m-%d ")作為表中的天數)tmp
- time是時間戳,days = 1代表星期日。
-用數據庫中的字段和表格替換時間和表格。
②
選擇IF(days = 1," yes "," no ")作為"是否是星期天" from(從表中選擇星期幾(date)作為天數)tmp
- date是2017-11-21的日期格式,days = 1代表星期日。
-用數據庫中的字段和表格替換日期和表格。