34,575
社区成员
发帖
与我相关
我的任务
分享
;WITH CTE AS
(
SELECT '2016-08-08 12:00:00' AS DT
UNION ALL
SELECT '2016-08-06 07:00:00' AS DT
)
SELECT STUFF(CONVERT(VARCHAR(7),CTE.DT,120),5,1,''),
YEAR(CTE.DT),
MONTH(CTE.DT)
FROM CTE
create database a
create database b
go
use a
go
create table test(ddate datetime)
insert into test values('2016-01-03 0:00:00')
select
CONVERT(varchar(6),ddate,112) SaleDate,
CONVERT(varchar(4),ddate,112) saleyear,
right(CONVERT(varchar(6),ddate,112),2) salemonth
into b..test from test
select * from b..test
go
use master
go
drop database a
drop database b
go