Specify date with string (OrderDate = '7/4/1996') : datetime « Data Types « SQL Server / T-SQL Tutorial

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>
2>
3> CREATE TABLE OrderDetails (
4>      OrderID int NOT NULL ,
5>      ProductID int NOT NULL ,
6>      UnitPrice money NOT NULL DEFAULT (0),
7>      Quantity smallint NOT NULL DEFAULT (1),
8>      Discount real NOT NULL DEFAULT (0)
9> )
10> GO
1> INSERT OrderDetails VALUES(10248,11,14,12,0)
2> INSERT OrderDetails VALUES(10248,42,9.8,10,0)
3> INSERT OrderDetails VALUES(10248,72,34.8,5,0)
4> INSERT OrderDetails VALUES(10249,14,18.6,9,0)
5> INSERT OrderDetails VALUES(10249,51,42.4,40,0)
6> INSERT OrderDetails VALUES(10250,41,7.7,10,0)
7> INSERT OrderDetails VALUES(10250,51,42.4,35,0.15)
8> INSERT OrderDetails VALUES(10250,65,16.8,15,0.15)
9> INSERT OrderDetails VALUES(10251,22,16.8,6,0.05)
10> INSERT OrderDetails VALUES(10251,57,15.6,15,0.05)
11> go

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)
1>
2>
3>    SELECT DISTINCT o.OrderDate, od.ProductID
4>    FROM Orders o
5>    JOIN OrderDetails od
6>      ON o.OrderID = od.OrderID
7>    WHERE OrderDate = '7/4/1996'
8> GO
OrderDate               ProductID
----------------------- -----------

(0 rows affected)
1>
2> drop table orders;
3> drop table OrderDetails;
4> GO

5.9.datetime
	5.9.1.	datetime type
	5.9.2.	Store the date and time for a change in a datetime format.
	5.9.3.	Billings on or before a specified date
	5.9.4.	A BETWEEN phrase with literal values
	5.9.5.	Using comperison operator with Date value
	5.9.6.	Between date
	5.9.7.	SET start_Date = GETDATE()
	5.9.8.	Use 'LIKE pattern' match with a date type value
	5.9.9.	An UPDATE statement that assigns new values to datetime column with string value
	5.9.10.	CAST(OrderDate AS varchar)
	5.9.11.	Specify date with string (OrderDate = '7/4/1996')
	5.9.12.	Performing Date Conversions
	5.9.13.	SELECT CONVERT(datetime, CONVERT( varchar(11), '2005-08-13 20:37:22.570', 101))
	5.9.14.	Add integer and float number to a date value
	5.9.15.	A SELECT statement that ignores date values
	5.9.16.	A SELECT statement that uses the CONVERT function to remove time values
	5.9.17.	A SELECT statement that uses the CAST function to remove time values
	5.9.18.	A SELECT statement that searches for month, day, and year components