ไปเจอตารางการ select ฟิลด์ที่เป็น datetime ให้ออกมาตาม format ต่างๆ เลยขอเอามาแปะกันลืมละกันนะ งิงิ
| SQL | Format | Result | | SELECT cast(DateField1 as varchar(11)) FROM Table1 | MMM dd yyyy | Aug 29 2006 | | SELECT cast(DateField1 as varchar(17)) FROM Table1 | MMM dd yyyy H:ii | Aug 29 2006 3:25 | | SELECT convert(varchar,DateField1) FROM Table1 | MMM dd yyyy H:iiA | Aug 29 2006 3:25PM | | SELECT convert(varchar,DateField1,111) FROM Table1 | yyyy/mm/dd | 2006/08/29 | | SELECT convert(varchar,DateField1,110) FROM Table1 | mm-dd-yyyy | 08-29-2006 | | SELECT convert(varchar,DateField1,010) FROM Table1 | mm-dd-yy | 08-29-06 | | SELECT convert(varchar,DateField1,101) FROM Table1 | mm/dd/yyyy | 08/29/2006 | | SELECT convert(varchar,DateField1,011) FROM Table1 | yy/mm/dd | 06/08/29 | | SELECT convert(varchar,DateField1,001) FROM Table1 | mm/dd/yy | 08/29/06 | | SELECT convert(varchar,DateField1,100) FROM Table1 | MMM dd yyyy H:iiA | Aug 29 2006 3:25PM | | SELECT convert(varchar,DateField1,102) FROM Table1 | yyyy.mm.dd | 2006.08.29 | | SELECT convert(varchar,DateField1,121) FROM Table1 | yyyy-mm-dd H:i:s.ms | 2006-08-29 15:25:33.000 | | SELECT convert(varchar,DateField1,012) FROM Table1 | yymmdd | 060829 | | SELECT convert(varchar(11),DateField1) FROM Table1 | MMM dd yyyy | Aug 29 2006 | | SELECT convert(varchar,DateField1,120) FROM Table1 | yyyy-mm-dd H:ii:ss | 2006-08-29 15:25:33 | | SELECT convert(varchar(10),DateField1,120) FROM Table1 | yyyy-mm-dd | 2006-08-29 | |