如何把’01/01/2004/ 08:00:00‘ 从char转换到日期型格式？

Question

select datediff(hour,cast(replace('01/01/2004/ 08:00:00','/',' ') as datetime),
cast(replace('01/03/2004/ 20:00:00','/',' ') as datetime))

Answer 1

select datediff(hour,cast(replace('01/01/2004/ 08:00:00','/ ',' ') as datetime),
cast(replace('01/03/2004/ 20:00:00','/ ',' ') as datetime))即只要把'01/01/2004/ 08:00:00'替换为'01/01/2004 08:00:00'就可正常转换了

Answer 2

--如何把’01/01/2004/ 08:00:00‘ 从char转换到日期型格式？
select cast(stuff('01/01/2004/ 08:00:00',11,1,'') as datetime)
--结果:2004-01-01 08:00:00.000
--或者从’01/01/2004/ 08:00:00‘ 到’01/03/2004/ 20:00:00‘ 能得出60小时的数字来？
select datediff(hour,stuff('01/01/2004/ 08:00:00',11,1,''),stuff('01/03/2004/ 20:00:00',11,1,''))
--结果:60

Answer 3

select convert(datetime,’01/01/2004/ 08:00:00',103)