Monday, July 31, 2006
怎樣將日期轉換成字串形式:YYYYMMDD,例如'2005-10-05' 轉換成'20051005'
SQL SERVER 怎樣將日期轉換成字串形式:YYYYMMDD,例如'2005-10-05' 轉換成'20051005'，謝謝！
ans:
select datetimefield,
convert(varchar(8), datetimefield, 112) as strdatetime
from yourtable
ans:
select datetimefield,
convert(varchar(8), datetimefield, 112) as strdatetime
from yourtable
# posted by 豬寶寶 @ 6:06 PM 
