會員註冊 / 登入  |  電腦版  |  Jump to bottom of page

SQL Server » 日期之年月日拆解及補0

發表人: andowson, 七段學員
2009-04-02 22:16:47
cast(datepart(yyyy, birthday) as varchar)+'年'+right('00'+cast(datepart(mm, birthday) as varchar), 2)+'月'+right('00'+cast(datepart(dd, birthday) as varchar), 2)+'日' as birthday_string


datepart(yyyy, birthday) AS birth_year, right('00'+cast(datepart(mm, birthday) as varchar), 2) AS birth_month, 

right('00'+cast(datepart(dd, birthday) as varchar), 2) AS birth_day




會員註冊 / 登入  |  電腦版  |  Jump to top of page