如何把由年月组成的varchar类型转换为datetime类型?用存储过程怎么做? RT,varchar类型中的数据如2009-4的年月数据,如何转换成datetime,convert等函数好像都不行,用存储过程可以吗,数据库是sqlserver2000,谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select cast('2009-4'+'-1' as datetime) declare @d varchar(10)set @d='2009-4'select cast(@d+'-1' as datetime) declare @d varchar(10)set @d='2009-4'select cast(@d+'-1' as datetime)/** ------------------------------------------------------ 2009-04-01 00:00:00.000(所影响的行数为 1 行)**/ declare @d varchar(10)set @d='2009-4'select cast(@d+'-1' as datetime)/*-----------------------2009-04-01 00:00:00.000(1 行受影响)*/ declare @d varchar(10)set @d='2009-4'select convert(datetime,@d+'-1')/*-----------------------2009-04-01 00:00:00.000(1 行受影响)*/ select cast('2009-4'+'-2' as datetime) select convert(datetime,'2009-4'+'-01',120) select convert(datetime,'2009-4'+'-01',120)/*2009-04-01 00:00:00.000*/ select cast( (select datestring from a)+'-1' as datetime) declare @t varchar(50)set @t='2009-04'select convert(datetime,replace(@t,'-','')+'01') select cast('2009-4'+'-2' as datetime)就可以啊 declare @str varchar(7)set @str='2009-01';select CONVERT(Datetime,@str+'-01',111);select CAST(@str+'-01' as datetime); declare @dt varchar(10)set @dt='2009-4'select convert(datetime,@dt+'-01',120) 导入数据 帮我看看这个句SQL如何实现。 有只讲C#的Windows窗体应用程序和SQL操作的书吗 关于 索引的问题 求 sql 语句 请问如何增加表的字段(字段名称是动态生成的)? 返回某字符串中最后一个特殊符号后面的字符串 MS SQL SERVER 2000无人值守安装脚本的写法 一个分类汇总的问题 这个问题让我茶饭不思。 数据库备份还原 从两个表中查询不可重复记录
set @d='2009-4'select cast(@d+'-1' as datetime)
set @d='2009-4'select cast(@d+'-1' as datetime)
/**
------------------------------------------------------
2009-04-01 00:00:00.000(所影响的行数为 1 行)
**/
set @d='2009-4'
select cast(@d+'-1' as datetime)
/*
-----------------------
2009-04-01 00:00:00.000(1 行受影响)
*/
set @d='2009-4'
select convert(datetime,@d+'-1')
/*
-----------------------
2009-04-01 00:00:00.000(1 行受影响)
*/
select cast('2009-4'+'-2' as datetime)
/*
2009-04-01 00:00:00.000
*/
select cast( (select datestring from a)+'-1' as datetime)
就可以啊
set @str='2009-01';
select CONVERT(Datetime,@str+'-01',111);
select CAST(@str+'-01' as datetime);
declare @dt varchar(10)
set @dt='2009-4'
select convert(datetime,@dt+'-01',120)