 |
|
SQL Select Datetime Format
Look at this example SQL statements, if you want to convert datetime field.
| 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
|
Replace DateField1 with your datetime field name and replace Table1 with your table name
| Comment no. 1 |
1
From ½ّ؟عضل³ذ Date 09/07/50 Time 18.02 [60.191.36.91]
|
| Comment no. 2 |
HOW TO CONVERT THIS STRING INTO DATETIME FORMAT
select CAST(CONVERT(VARCHAR(12),'Sat Aug 25 00:00:00 2007',107) AS DATETIME)
From RASHIM Date 29/09/50 Time 12.23 [202.126.122.162]
|
| Comment no. 3 |
We sell store online.
From 1 Date 02/12/50 Time 23.18 [60.190.240.76]
|
| Comment no. 4 |
how to convert datetime field into mm-dd-yyyy HH:II AM/PM varchar format.
From Ajay Date 10/12/50 Time 11.33 [203.109.120.138]
|
|
|
