随笔- 31 文章- 6 评论- 0

把时间转换成你要的格式

SELECT cast(DATEPART(yy, '') AS varchar)+'-'+ cast(DATEPART(mm, '2009-6-15 15:29:40') AS varchar) AS 'Month Number'

posted @ 2009-06-26 10:49 錒飛阅读(20) 评论(0) 编辑收藏