SQL Select Datetime Format

ที่มา: http://dexterian.exteen.com/20080718/sql-select-datetime-format

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