select cast(datepart(year,getdate()) as varchar(4)) + '0' +cast(datepart(month,getdate()) as varchar(2)) + cast(datepart(day,getdate()) as varchar(2)) + cast(datepart(hour,getdate()) as varchar(2)) + cast(datepart(minute,getdate()) as varchar(2)) + cast(datepart(second,getdate()) as varchar(2)) /**
--------------- 20090811161315(所影响的行数为 1 行) **/
declare @s datetime set @s=getdate() select stuff(stuff(stuff(stuff(stuff(convert(varchar,@s,120),5,1,''),7,1,''),9,1,''),11,1,''),13,1,'')我这个也可以撒。。只是好麻烦,汗。昨天在这里面新学的一个,今天拿来献丑,呵呵
/*----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
20090810101318(所影响的行数为 1 行)
*/
DECLARE @TIME DATETIME
SET @TIME='2009-08-10 10:07:05'
SELECT REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(20),@TIME,120),' ',''),':',''),'-','')
20090810100705
select replace(replace(replace(CONVERT(varchar(20) , getdate(), 120),'-','' ),':',''),' ','')
-------------
20090810101435(所影响的行数为 1 行)
replace(
replace(
replace(
convert(varchar(20),getdate(),120)
,'-','')
,' ','')
,':',''))
replace()这个函数依次去掉 - 空格 :
select replace(replace(replace(convert(varchar(20),getdate(),120),'-',''),' ',''),':','')这样就可以,转换后将该替换的替换掉
select replace(replace(replace(CONVERT(varchar,'2009-08-10 10:07:05',120),'-',''),' ',''),':','')
注意:2009-08-10 10:07:05 必须加单引号 若用getdate()函数则不用加单引号
给你介绍一些常用的日期转换参数,值得收藏select CONVERT(varchar, getdate(), 120 )
2004-09-12 11:06:08select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')
20040912110608select CONVERT(varchar(12) , getdate(), 111 )
2004/09/12select CONVERT(varchar(12) , getdate(), 112 )
20040912select CONVERT(varchar(12) , getdate(), 102 )
2004.09.12其它我不常用的日期格式转换方法:select CONVERT(varchar(12) , getdate(), 101 )
09/12/2004select CONVERT(varchar(12) , getdate(), 103 )
12/09/2004select CONVERT(varchar(12) , getdate(), 104 )
12.09.2004select CONVERT(varchar(12) , getdate(), 105 )
12-09-2004select CONVERT(varchar(12) , getdate(), 106 )
12 09 2004select CONVERT(varchar(12) , getdate(), 107 )
09 12, 2004select CONVERT(varchar(12) , getdate(), 108 )
11:06:08select CONVERT(varchar(12) , getdate(), 109 )
09 12 2004 1select CONVERT(varchar(12) , getdate(), 110 )
09-12-2004select CONVERT(varchar(12) , getdate(), 113 )
12 09 2004 1select CONVERT(varchar(12) , getdate(), 114 )
11:06:08.177
select cast(datepart(year,getdate()) as varchar(4)) +
'0' +cast(datepart(month,getdate()) as varchar(2))
+
cast(datepart(day,getdate()) as varchar(2))
+
cast(datepart(hour,getdate()) as varchar(2))
+
cast(datepart(minute,getdate()) as varchar(2))
+
cast(datepart(second,getdate()) as varchar(2))
/**
---------------
20090811161315(所影响的行数为 1 行)
**/
set @s=getdate()
select stuff(stuff(stuff(stuff(stuff(convert(varchar,@s,120),5,1,''),7,1,''),9,1,''),11,1,''),13,1,'')我这个也可以撒。。只是好麻烦,汗。昨天在这里面新学的一个,今天拿来献丑,呵呵