select ISNULL(cast(year(birthdate) as VARchar(10))
+'-'+cast(month(birthdate) as VARchar(10))
+'-'+cast(day(birthdate) as VARchar(10))
,'日期不详') as 日期 from employees;
select cast(year(getdate()) as varchar(10)) + '年'
+ cast(month(getdate()) as varchar(10)) + '月'
+ cast(day(getdate()) as varchar(10)) + '日'
+'-'+cast(month(birthdate) as VARchar(10))
+'-'+cast(day(birthdate) as VARchar(10))
,'日期不详') as 日期 from employees;
select cast(year(getdate()) as varchar(10)) + '年'
+ cast(month(getdate()) as varchar(10)) + '月'
+ cast(day(getdate()) as varchar(10)) + '日'
扫一扫
6501
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
