1 select DATE_FORMAT(dtl.transdate,"%Y-%m-%d") as transdate, 2 right(DATE_FORMAT(concat(transdat
1 select DATE_FORMAT(dtl.transdate,"%Y-%m-%d") as transdate,
2 right(DATE_FORMAT(concat(transdate,transtime),"%Y-%m-%d %H:%i:%s"),8) as
3 transtime,dtl.custname,dtl.stuempno,dtl.deviceid,dtl.devtype,dev.devicename,a.names as areaname
4 from t_devicedtl dtl
5 left join t_device dev on dev.deviceid=dtl.deviceid
6 left join t_area a on a.id=dev.areaid
--结束END--
本文标题: mysql日期格式化
本文链接: https://www.lsjlt.com/news/6847.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-23
2024-04-23
2024-04-23
2024-04-23
2024-04-23
2024-04-23
2024-04-23
2024-04-23
2024-04-23
2024-04-23
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0