Mega Code Archive
CONVERT(varchar(12), OrderDate, 111)
<![CDATA[
4>
5> CREATE TABLE Orders (
6> OrderID int NOT NULL ,
7> CustomerID nchar (5) NULL ,
8> EmployeeID int NULL ,
9> OrderDate datetime NULL ,
10> RequiredDate datetime NULL ,
11> ShippedDate datetime NULL ,
12> ShipVia int NULL ,
13> Freight money NULL DEFAULT (0),
14> ShipName nvarchar (40) NULL ,
15> ShipAddress nvarchar (60) NULL ,
16> ShipCity nvarchar (15) NULL ,
17> ShipRegion nvarchar (15) NULL ,
18> ShipPostalCode nvarchar (10) NULL ,
19> ShipCountry nvarchar (15) NULL
20> )
21> GO
1>
2> SELECT OrderDate, CONVERT(varchar(12), OrderDate, 111) AS "Converted"
3> FROM Orders
4> WHERE OrderID = 11050
5> GO
OrderDate Converted
----------------------- ------------
(0 rows affected)
1>
2> drop table orders;
3> GO
]]>