日時を日本の形式に変換
日時を日本の形式（YYYY/MM/DD HH:MM:DD）に変換する方法です。
SELECT NAME,BUYDATE,
CONVERT(VARCHAR,BUYDATE,111) + ' ' +CONVERT(VARCHAR,BUYDATE,108)
AS CONVDATEFROM PC
| NAME | BUYDATE | CONVDATE |
|---|---|---|
| CL-BAD | 1900-01-01 00:00:00.000 | 1900/01/01 00:00:00 |
| CL-NONE | NULL | NULL |
| CL-SAITO | 2000-03-15 14:10:05.000 | 2000/03/15 14:10:05 |
| CL-SHARE | 1995-06-13 00:00:00.000 | 1995/06/13 00:00:00 |
| CL-UEDA | 2001-01-11 18:20:15.000 | 2001/01/11 18:20:15 |
| CL-YOSHIDA | 2000-03-12 00:00:00.000 | 2000/03/12 00:00:00 |
| SV-FILE | 2000-08-01 00:00:00.000 | 2000/08/01 00:00:00 |
| 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/01/11 01:03:18 |