SQL语句中将Datetime类型转换为字符串类型
摘要:
0Feb 22 2006 4:26PMCONVERT(CHAR(19), CURRENT_TIMESTAMP, 0)102/22/06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1)206.02.22CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2)322/02/06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3)422.02.06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4)522-02-06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5)622 Feb 阅读全文
posted @ 2013-11-28 09:35 CANYOUNG 阅读(4340) 评论(0) 推荐(0) 编辑