mysql日期格式化问题
select OrganLevelName,papername,DATE_FORMAT(tp.DateCreated,'%Y-%m-%d %H:%i') as DateCreated,
tp.tpid,SavePaper,PaperSource,
CONCAT( DATE_FORMAT(ExamBegin,'%Y-%m-%d %H:%i'),
' - ', DATE_FORMAT(ExamEnd,'%Y-%m-%d %H:%i'))
AS Exam,
SelectedMode,UserAlias
from tbtestpaper tp inner join tbPaperClass pc
on tp.PCID=pc.PCID
inner join tbUser tu
on tp.CreateUserID=tu.UserID
inner join tbOrgan org
on pc.OrganID=org.OrganID
where 1=1order by tp.DateCreated desc
页:
[1]