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