目的:
把日期型数据转换为整型
比如:
2002-9-13 14:36:48 to 0209131436
---------------------------------------------------------------
select right(convert(char(8),getdate(),112),6)+
left(convert(varchar(10),getdate(),108),2)+
substring(convert(varchar(10),getdate(),108),4,2)
---------------------------------------------------------------
select cast(substring(replace(replace(replace(convert(char(30),getdate(),20),'-',''),' ',''),':',''),3,10) as int)
---------------------------------------------------------------
select datepart(year,getdate())% 100 * 100000000
+ datepart(month,getdate())*1000000
+ datepart(day,getdate())*10000
+ datepart(hour,getdate())*100
+ datepart(minute,getdate())