sql server 怎么才能设定只获取年月部分(yyyymm)...急...!!!!1

[celly2008]

sql server 怎么才能设定只获取年月部分并且按照yyyymm的格式显示.....

[刀枪blue]

cast

[gwins]

year(getDate())+month(getDate())+day(getDate())

[greatverve]

C#里设定吧，DateTime类。
sql server好像没有这种语法。

[greatverve]

year(),month()学习了。试试。

[clear_shadow]

DateTime.Now.ToString("yyyyMM");

[wuyq11]

year(getDate())+month(getDate())

[warrior]

select convert(nvarchar(6),datefield,112) from table1

[jiangshun]

convert(varchar(),字段,时间类型)

[zggyh]

convert()的第3个参数可以设置 显示形式

[wuyq11]

SUBSTRING(cast(getdate()as varchar),1,4)+SUBSTRING(cast(getdate()as varchar,6,2);

[jiezi316]

[Quote=引用 7 楼 warrior 的回复:]
SQL code
select convert(nvarchar(6),datefield,112) from table1
[/Quote]
UP

[takako_mu]

学习了，在C#做会更好一些。

[lovehongyun]

select convert(varchar ,getdate(),112)

select cast(year(getDate()) as varchar)+cast(month(getDate()) as varchar)+cast(day(getDate()) as varchar)

这两个都行

[lovehongyun]

2楼的不对.

[Jack123]

112

[Fibona]

sql语句里面用cast进行转换

比如说表里面的createdate字段
select cast(year(cast (createdate as datetime)) as varchar(4)) + cast( month(cast (createdate as datetime)) as varchar(2)) +cast(day(cast (createdate as datetime)) as varchar(2)) from table

如果createdate字段是日期型的
select cast(year(createdate) as varchar(4)) + cast( month(createdate) as varchar(2)) +cast(day(createdate) as varchar(2)) from table

如果是C#可以用DateTime.ToString("yyyy-MM-dd")来实现

[宇鹰NB]

select convert(nvarchar(6),getdate(),112)