字符串转成日期

2010-12-23 09:16:41 223 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

以梦为马-不负韶华墨衍会员 · AI 创作全网分发关注 + 加入社区

数学建模灵敏性分析（一阶、二阶灵敏度）python代码+懒人专用版对于勉强看懂了灵敏度分析的同学来说，本文给出一个方便移植、修改的python程序，可以很方便地进行灵敏度分析。阅读详情

把这样的字符串 2010 01 07 08 01 40

转换成日期格式

2010-01-07 08:01:40

？？？？？？？？？

...全文

手把手教你实现阿克曼ROS小车的运动控制本文详细介绍了如何从零开始实现阿克曼ROS小车的运动控制。内容涵盖硬件搭建、STM32底层PID速度与舵机控制、ROS层阿克曼运动学模型解析，以及上下位机通信协议设计。通过手把手的代码示例和调试步骤，帮助机器人爱好者与开发者掌握将高级速度指令转化为小车具体动作的全流程，实现流畅的阿克曼转向控制。阅读详情

以梦为马-不负韶华

疑难问题 22,298 成员 121,727 内容

+ 关注 + 加入社区

切换为时间正序

以梦为马-不负韶华 2010-12-24

打赏
举报

O(∩_∩)O谢谢大家

soulJava 2010-12-23

打赏
举报



select convert(datetime,replace(substring('2010 01 07 08 01 40',0,11),' ','-')+' '+replace(substring('2010 01 07 08 01 40',12,20),' ',':'),120)

cs_lb 2010-12-23

打赏
举报



select CAST(stuff(stuff('2010 01 07 08 01 40',14,1,':'),17,1,':')AS DATETIME)

fpzgm 2010-12-23

打赏
举报

declare @str nvarchar(100)

set @str='2010 01 07 08 01 40'

select cast(replace(left(@str,10),' ','-')+' '+replace(RIGHT(@str,8),' ',':') as datetime)



/*

2010-01-07 08:01:40.000

*/

WaterGG 2010-12-23

打赏
举报

declare @d varchar(50)

set @d='2010 01 07 08 01 40'



select stuff(stuff(stuff(replace(@d,' ','-'),11,1,' '),14,1,':'),17,1,':')





2010-01-07 08:01:40



(1 行受影响)

水族杰纶 2010-12-23

打赏
举报

/*

---------------------

2010-01-07 08:01:40



(1 row(s) affected)

*/

水族杰纶 2010-12-23

打赏
举报

select stuff(stuff(stuff(stuff('2010 01 07 08 01 40',5,1,'-'),8,1,'-'),14,1,':'),17,1,':')

cs_lb 2010-12-23

打赏
举报



if exists (select * from sysobjects where name='p_time')

drop procedure p_time

GO

create proc p_time

as

declare @riqi varchar(50)

declare @shijian varchar(50)

declare @uid varchar(50)

declare myCursor cursor for

select [user_Id],fillDate from cj_yonghu where isDate(fillDate)=0

open myCursor

fetch next from myCursor into @uid,@shijian

while @@fetch_status=0

begin

set @riqi=CONVERT(varchar(50),convert(datetime,substring(left(@shijian,8)+' ' + substring(@shijian,9,2)+':' + substring(@shijian,11,2)+':' + substring(@shijian,13,2),1,20)),120) --120为你想要的格式，109为你的默认格式 

update cj_yonghu set fillDate=@riqi

where [user_Id]=@uid

fetch next from myCursor into @uid,@shijian

end

close myCursor

deallocate myCursor

--print @uid  

print @shijian

print @riqi

GO



exec p_time

cs_lb 2010-12-23

打赏
举报

这样改



if exists (select * from sysobjects where name='p_time')

drop procedure p_time

GO

create proc p_time

as

declare @riqi varchar(50)

declare @shijian varchar(50)

declare @uid varchar(50)

declare myCursor cursor for

select [user_Id],fillDate from cj_yonghu where isDate(fillDate)=0

open myCursor

fetch next from myCursor into @uid,@shijian

while @@fetch_status=0

begin

set @riqi=CONVERT(varchar(50),convert(datetime,substring(left(@shijian,8)+' ' + substring(@shijian,9,2)+':' + substring(@shijian,11,2)+':' + substring(@shijian,13,2),1,20)),109)  

update cj_yonghu set fillDate=@riqi

where [user_Id]=@uid

fetch next from myCursor into @uid,@shijian

end

close myCursor

deallocate myCursor

--print @uid  

print @shijian

print @riqi

GO



exec p_time

以梦为马-不负韶华 2010-12-23

打赏
举报

大家帮我看看我的代码

if exists (select * from sysobjects where name='p_time')
drop procedure p_time
GO
create proc p_time
as
declare @riqi varchar(50)
declare @shijian varchar(50)
declare @uid varchar(50)
declare myCursor cursor for
select [user_Id],fillDate from cj_yonghu where isDate(fillDate)=0
open myCursor
fetch next from myCursor into @uid,@shijian
while @@fetch_status=0
begin
set @riqi=convert(datetime,substring(left(@shijian,8)+' ' + substring(@shijian,9,2)+':' + substring(@shijian,11,2)+':' + substring(@shijian,13,2),1,20))
update cj_yonghu set fillDate=@riqi
where [user_Id]=@uid
fetch next from myCursor into @uid,@shijian
end
close myCursor
deallocate myCursor
--print @uid
print @shijian
print @riqi
GO

exec p_time

执行结果：
20100107080140
01 7 2010 8:01AM 这个格式不对呀！
我要转换成 2010-01-07 08:01:40.000

帮我看看怎么修改？？

字符串转成日期

相关推荐