年月日時分秒を個別に取得
SELECT NAME,BUYDATE,
YEAR(BUYDATE) AS [YY],
MONTH(BUYDATE) AS [MM],
DAY(BUYDATE) AS [DD],
DATEPART(HOUR, BUYDATE) AS [HH],
DATEPART(MINUTE, BUYDATE) AS [MI],
DATEPART(SECOND, BUYDATE) AS [SS]
FROM PC
NAME | BUYDATE | YY | MM | DD | HH | MI | SS |
---|---|---|---|---|---|---|---|
CL-BAD | 1900-01-01 00:00:00.000 | 1900 | 1 | 1 | 0 | 0 | 0 |
CL-NONE | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
CL-SAITO | 2000-03-15 14:10:05.000 | 2000 | 3 | 15 | 14 | 10 | 5 |
CL-SHARE | 1995-06-13 00:00:00.000 | 1995 | 6 | 13 | 0 | 0 | 0 |
CL-UEDA | 2001-01-11 18:20:15.000 | 2001 | 1 | 11 | 18 | 20 | 15 |
CL-YOSHIDA | 2000-03-12 00:00:00.000 | 2000 | 3 | 12 | 0 | 0 | 0 |
SV-FILE | 2000-08-01 00:00:00.000 | 2000 | 8 | 1 | 0 | 0 | 0 |
SV-MAIL | 1999-12-16 13:50:52.000 | 1999 | 12 | 16 | 13 | 50 | 52 |
SV-WEB | 2001-01-11 01:03:18.000 | 2001 | 1 | 11 | 1 | 3 | 18 |
上記ではYEAR、MONTH、DAYといった関数を使用しましたが、年月日もDATEPARTで取得することができます。