Use 'LIKE pattern' match with a date type value : datetime « Data Types « SQL Server / T-SQL Tutorial

8> CREATE TABLE titles(
9>    title_id       varchar(20),
10>    title          varchar(80)       NOT NULL,
11>    type           char(12)          NOT NULL,
12>    pub_id         char(4)               NULL,
13>    price          money                 NULL,
14>    advance        money                 NULL,
15>    royalty        int                   NULL,
16>    ytd_sales      int                   NULL,
17>    notes          varchar(200)          NULL,
18>    pubdate        datetime          NOT NULL
19> )
20> GO
1>
2> insert titles values ('1', 'Secrets',   'popular_comp', '1389', $20.00, $8000.00, 10, 4095,'Note 1','06/12/94')
3> insert titles values ('2', 'The',       'business',     '1389', $19.99, $5000.00, 10, 4095,'Note 2','06/12/91')
4> insert titles values ('3', 'Emotional', 'psychology',   '0736', $7.99,  $4000.00, 10, 3336,'Note 3','06/12/91')
5> insert titles values ('4', 'Prolonged', 'psychology',   '0736', $19.99, $2000.00, 10, 4072,'Note 4','06/12/91')
6> insert titles values ('5', 'With',      'business',     '1389', $11.95, $5000.00, 10, 3876,'Note 5','06/09/91')
7> insert titles values ('6', 'Valley',    'mod_cook',     '0877', $19.99, $0.00,    12, 2032,'Note 6','06/09/91')
8> insert titles values ('7', 'Any?',      'trad_cook',    '0877', $14.99, $8000.00, 10, 4095,'Note 7','06/12/91')
9> insert titles values ('8', 'Fifty',     'trad_cook',    '0877', $11.95, $4000.00, 14, 1509,'Note 8','06/12/91')
10> 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>
2>
3> select * from titles WHERE pubdate LIKE 'Jul  8 1996%'
4> GO
title_id             title                                                                            type         pub_id price                 advance               royalty     ytd_sales   notes
                                                                                                                                                                                               pubdate

-------------------- -------------------------------------------------------------------------------- ------------ ------ --------------------- --------------------- ----------- ----------- ----------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------
--------------

(0 rows affected)
1> drop table titles;
2> GO
1>
2>

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