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

### 利用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