聽說幸福…在山的那邊 (浪機子)

### 利用SQL直接秀出YYYY/MM/DD的型態 ###

select  top 1 onthejobdate from traininginq

select  top 1 convert(char(10),onthejobdate,111) from Traininginq

select  top 1 convert(char(10),dateadd("d",0,onthejobdate),111) from Traininginq

### 日期型態介紹，其他的請自已試囉 ###

select  top 1 convert(char(10),dateadd("d",0,onthejobdate),107) t107,

       convert(char(10),dateadd("d",0,onthejobdate),108) t108,

       convert(char(10),dateadd("d",0,onthejobdate),109) t109,

       convert(char(10),dateadd("d",0,onthejobdate),110) t110,

       convert(char(10),dateadd("d",0,onthejobdate),111) t111,

       convert(char(10),dateadd("d",0,onthejobdate),112) t112,

       convert(char(10),dateadd("d",0,onthejobdate),113) t113,

        convert(char(10),dateadd("d",0,onthejobdate),114) t114

from Traininginq

### 日期加減介紹，其他的請自已試囉 ###

select  top 1 convert(char(10),dateadd("d",1,onthejobdate),112) dd,

       convert(char(10),dateadd("m",1,onthejobdate),112) mm,

       convert(char(10),dateadd("yy",1,onthejobdate),112) yy from Traininginq