SQL Select Datetime Format

posted on 18 Jul 2008 18:01 by dexterian in database

ไปเจอตารางการ 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