会者不难! 关于日期数据类型转换

目的:
把日期型数据转换为整型
比如:
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())

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus