sql 新建视图，日期以及选择显示

最新推荐文章于 2024-04-29 21:08:01 发布

lfl18326162160

最新推荐文章于 2024-04-29 21:08:01 发布

阅读量141

点赞数

文章标签：大数据 sql

本文链接：https://blog.csdn.net/lfl18326162160/article/details/132334902

版权

SELECT
   `fs_workingset`.`ID` AS `ID`,
   date_format(
       `fs_workingset`.`CREATETIME`,
       '%Y-%c-%d %H:%i:%S'
   ) AS `CREATETIME`,
   `fs_workingset`.`CREATER` AS `CREATER`,
   date_format(
       `fs_workingset`.`LASTMODIFYTIME`,
       '%Y-%c-%d %H:%i:%S'
   ) AS `LASTMODIFYTIME`,
   `fs_workingset`.`MODIFIER` AS `MODIFIER`,
   `fs_workingset`.`ORGID` AS `ORGID`,
   `fs_workingset`.`MATID` AS `MATID`,
   `fs_workingset`.`WORKINGNO` AS `WORKINGNO`,
   (
       CASE `fs_workingset`.`INVALID`
       WHEN 1 THEN
           '有效'
       WHEN 0 THEN
           '无效'
       END
   ) AS `INVALID`,
   `fs_workingset`.`WORKINGNAME` AS `WORKINGNAME`,
   `fs_workingset`.`REMARK` AS `REMARK`,
   `fs_workingset`.`WORKCENTERID` AS `WORKCENTERID`,
   `fs_workingset`.`WORKCENTERNAME` AS `WORKCENTERNAME`
FROM
   `fs_workingset`