case when len(cast(MONTH(GETDATE()) as varchar(2)) )=1 then '0'+cast(MONTH(GETDATE()) as varchar(2)) else cast(MONTH(GETDATE()) as varchar(2)) case when len(cast(day(GETDATE())-1 as varchar(2)) )=1 then '0'+cast(MONTH(GETDATE()) as varchar(2)) else cast(day(GETDATE())-1 as varchar(2))
不行呢?我的机器是这样的设置的,我是访问别的机器的数据库,select substring(cast (year(getdate()) as varchar(4)),3,2) + cast(MONTH(GETDATE()) as varchar(2)) +cast(day(GETDATE())-1 as varchar(2)) 还是显示0392,我在数据库的机器也是改了设置,还是一样的显示0392这个东西如何解释???
select a=right('00'+cast(MONTH(GETDATE()) as varchar(2)) ,2)
case when len(cast(day(GETDATE())-1 as varchar(2)) )=1 then '0'+cast(MONTH(GETDATE()) as varchar(2)) else cast(day(GETDATE())-1 as varchar(2))
还是显示0392,我在数据库的机器也是改了设置,还是一样的显示0392这个东西如何解释???
select a=right('00'+cast(MONTH(GETDATE()) as varchar(2)) ,2)