拆分日期

Question

數據空表A一字段A01 datetime 字段長度為18
A01='2009-04-09 00:00:00.000'我現在想將該字段拆分成3個字段分別保存：年份、月份及天
'2009',          '04',         '09'
left(A01,4)        ?              ?

Answer 1

select datename(yy,getdate())
select datename(mm,getdate())
select datename(dd,getdate())

Answer 2

SELECT DATENAME(YY,TIME),DATENAME(MM,TIME),DATENAME(DD,TIME)

Answer 3

declare @A01 datetime
set @A01='2009-04-09 00:00:00.000'
select  年 =datename(yy,@A01),
月=datename(mm,@A01),
日=datename(dd,@A01)
/*
年                              月                              日                              
------------------------------ ------------------------------ ------------------------------ 
2009                           04                             9（所影响的行数为 1 行）*/

Answer 4

select datename(yy,getdate()),datename(mm,getdate()),datename(dd,getdate())

Answer 5

因为你系统是繁体中文，所以会出现这个。可以用DATEPART
declare @A01 datetime
set @A01='2009-04-09 00:00:00.000'
select  年 =datepart(yy,@A01),
    月=datepart(mm,@A01),
    日=datepart(dd,@A01)