<![CDATA[Latest posts for the topic "日期之年月日拆解及補0"]]> https://forum.andowson.com/posts/list/12.page JForum - http://www.jforum.net 日期之年月日拆解及補0
[code]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[/code]]]> https://forum.andowson.com/posts/preList/310/580.page https://forum.andowson.com/posts/preList/310/580.page GMT