陳述句
【
SELECT
*
FROM
(SELECT
b.team_id AS '團隊id',
a.vid AS '專案id',
a.tid AS '任務id',
a.uid AS '分享人id',
a.mark_uid AS '做題人id',
a.amount AS '題目金額',
a.`desc` AS '任務名稱',
from_unixtime( time,"%Y-%m-%d") AS '時間'
FROM
tb_totoro_task_share_settlement AS a,
tb_team_account_online AS b
WHERE
a.uid = b.uid
)AS total
WHERE
'時間'>=UNIX_TIMESTAMP('2019-06-29')
AND
'時間'<UNIX_TIMESTAMP('2019-10-15')
】
查不出來結果，哪位幫忙看下。
uj5u.com熱心網友回復：
【SELECT
*
FROM
(SELECT
b.team_id AS '團隊id',
a.vid AS '專案id',
a.tid AS '任務id',
a.uid AS '分享人id',
a.mark_uid AS '做題人id',
a.amount AS '題目金額',
a.`desc` AS '任務名稱',
a.time
FROM
tb_totoro_task_share_settlement AS a,
tb_team_account_online AS b
WHERE
a.uid = b.uid
)AS total
WHERE
time >1569859200
AND
time <1571068800
】
目前這條陳述句可以查出來，但是出來的是時間戳的格式，怎么修改陳述句可以直接展示出data形式的日期？
uj5u.com熱心網友回復：
SELECTb.team_id AS '團隊id',
a.vid AS '專案id',
a.tid AS '任務id',
a.uid AS '分享人id',
a.mark_uid AS '做題人id',
a.amount AS '題目金額',
a.`desc` AS '任務名稱',
FROM_UNIXTIME( a.time, "%Y-%m-%d" ) AS '時間'
FROM
tb_totoro_task_share_settlement AS a,
tb_team_account_online AS b
WHERE
a.uid = b.uid
AND FROM_UNIXTIME( a.time, "%Y-%m-%d" ) >= '2019-06-29'
AND FROM_UNIXTIME( a.time, "%Y-%m-%d" ) < '2019-10-15'
uj5u.com熱心網友回復：
感謝！轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/43471.html
標籤：MySQL