sqlserver 将 FCreateTime 时间戳字段 转换为date类型字段

SELECT CONVERT(varchar(100), FCreateTime, 23)   from CT_MW_MWContract

 

 SELECT FID FROM CT_MW_MWContract WHERE     CFContractStatu!=3  and   CFEffe<=convert(datetime,'2021-03-02')     and     CONVERT(varchar(100), FCreateTime, 23) <=convert(datetime,'2021-03-02')   and  fid='jRQAAAAC+bjOKo6F'