注册 登录
编程论坛 SQL Server论坛

哪位大佬帮我把oper_date时间改成今日的,谢谢

f1145714329 发布于 2020-07-04 10:07, 1416 次点击
select '审核标志' = ( CASE approve_flag  WHEN '1' then '已审核'    WHEN '0' then '未审核'    ELSE '其它'   END ), sheet_no, branch_no,(select branch_name from t_bd_branch_info where branch_no=t_pm_sheet_master.branch_no) 仓库名称, supcust_no,(select sup_name from t_bd_supcust_info where supcust_no = t_pm_sheet_master.supcust_no) as 供应商名称,sheet_amt, oper_id, oper_date,relate_sheet_no as 关联单号, '备注'=other1  from t_pm_sheet_master  order by oper_date desc
1 回复
#2
oldfish962020-07-26 02:27
    加 CONVERT(varchar(100), GETDATE(), 23)?
1