07 2011 档案

SQL时间格式转换CONVERT_GETDATE()
摘要：SQL时间格式转换：年月日SELECT CONVERT(varchar, GETDATE(), 102) AS DateTime--2011.07.12SELECT CONVERT(varchar, GETDATE(), 111) AS DateTime--2011/07/12SELECT CONVERT(varchar(10), GETDATE(), 120) AS DateTime--2011-07-12SELECT CONVERT(varchar, GETDATE(), 112) AS DateTime--20110712SELECT CONVERT(varchar, GETDATE() 阅读全文
posted @ 2011-07-12 16:50 danch 阅读(850) 评论(0) 推荐(1) 编辑