语句
【
SELECT
*
FROM
(SELECT
b.team_id AS '团队id',
a.vid AS '项目id',
a.tid AS '任务id',
a.uid AS '分享人id',
a._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')
】查不出来结果,哪位帮忙看下。
【
SELECT
*
FROM
(SELECT
b.team_id AS '团队id',
a.vid AS '项目id',
a.tid AS '任务id',
a.uid AS '分享人id',
a._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')
】查不出来结果,哪位帮忙看下。
SELECT
*
FROM
(SELECT
b.team_id AS '团队id',
a.vid AS '项目id',
a.tid AS '任务id',
a.uid AS '分享人id',
a._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形式的日期?
b.team_id AS '团队id',
a.vid AS '项目id',
a.tid AS '任务id',
a.uid AS '分享人id',
a._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'