練功房推薦書單

  • 猛虎出柙雙劍合璧版--最新 OCA / OCP Java SE 7 Programmer 專業認證 (電子書)
  • 流浪教師存零股存到3000萬(全新增修版)(書+DVD)
  • 開始在關西自助旅行(京都‧大阪‧神戶‧奈良)(全新增訂版)
  • 不敗教主的300張股票存股術
日期之年月日拆解及補0 RSS feed
Forum Index » SQL Server
Author Message
andowson

七段學員
[Avatar]

Joined: 2007/1/2
Messages: 706
Location: 台北
Offline
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

分享經驗 累積智慧
[WWW] [MSN]
 
Forum Index » SQL Server
Go to:   
Mobile view