sql server 截取日期及其获取当天的记录

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)