select CONVERT(CHAR(5),YEY_KQB_SJ,108),YEY_KQB_BS from YEY_KQB where YEY_KQB_ZGH='1900009' and YEY_KQB_RQ=CONVERT(varchar,GETDATE(),23)
sql server 截取日期及其获取当天的记录
最新推荐文章于 2024-05-13 19:57:31 发布
select CONVERT(CHAR(5),YEY_KQB_SJ,108),YEY_KQB_BS from YEY_KQB where YEY_KQB_ZGH='1900009' and YEY_KQB_RQ=CONVERT(varchar,GETDATE(),23)