如何用格式化的函數如將：2008/11/02 轉換成20081102
急用啊
謝謝

没测试 你试下
CAST(Year(日期) AS VARCHAR(10)) +   
                 CASE WHEN LEN(CAST(MONTH(日期) AS VARCHAR(10)))<2
                      THEN '0' + CAST(MONTH(日期) AS VARCHAR(10))
                      ELSE CAST(MONTH(日期) AS VARCHAR(10))  END  +   
                 CASE WHEN LEN(CAST(DAY(日期) AS VARCHAR(10)))<2
                      THEN '0' + CAST(DAY(日期) AS VARCHAR(10))
                      ELSE CAST(DAY(日期) AS VARCHAR(10))  END