MYsql数据库date_format格式化年月日 CASE WHEN 使用

作者官方网站:http://www.wxl568.cn 

select l.empCode             "工号",
       l.empName             "姓名",
       l.orgName             "组织名称",
       l.posname             "职位名称",
        date_format(l.clockTime,'%Y-%m-%d') "打卡日期",
       date_format(l.clockTime,'%H:%i:%S')  "打卡时间",
        CASE l.RESERVE3 WHEN 100 THEN "开心"
  WHEN 200 THEN "一般" 
    WHEN 300 THEN "不开心"
   ELSE "未开放" END
as "情绪",
       l.addressName         "考勤点名称",
       l.outsideClockAddress "外勤地址",
       l.macAddress          "MAC网卡",
       l.clVersion           "版本号"
  from tt_big_clock_log_data l
inner join ts_clock_user_org uo on uo.org_id = l.orgId    
inner join tm_org t on t.ORG_ID=l.orgId
 where 1 = 1 and uo.emp_code='调' 
 and exists
 (
select 1 from (select ORG_ID nodeId, ORG_NAME nodeName, (case when ORG_ID_PARENT = 0 then 1 else ORG_ID_PARENT end) parentNodeId from tm_org where ORG_ID_PARENT in(10001250,10001258)) t 
 where l.orgId = t.ORG_ID 
 )
 
 order by l.clockTime desc