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 |
Tuesday, June 16, 2009
SQL Select Datetime Format
ที่มา: http://dexterian.exteen.com/20080718/sql-select-datetime-format
No comments:
Post a Comment