TRANSACT - SQL:

Assume we have database EntertainmentAgencyExample with the following tables:

And here is the info regarding the table we need:

I need to do this query:

Show me any engagements in October 2017 that start between noon and 5 p.m.

My code is:

SELECT EngagementNumber, StartDate, EndDate, StartTime, StopTime FROM Engagements WHERE (StartDate = '2017-10-01') AND (StartTime >= '12.00' and StopTime

Microsoft SQL Server outputs the following mistake: Conversion failed when converting date and/or time from character string.

I tried to cast it but without big success. Thanks for your help.

EntertainmentAgency Example Database Diagrams Tables System Tables File Tables External Tables Graph Tables dbo.Agents dbo.Customers dbo.Engagements dbo.Entertainer_Memb. dbo.Entertainer_Styles dbo.Entertainers dbo. Members dbo.Musical_Preference dbo.Musical_Styles dbo.ztblDays dbo.ztb Months dbo.ztblSkipLabels dbo.ztblWeeks /****** Script for SelectTopNRows command from SSMS ******/ SELECT TOP (1000) [Engagement Number] [StartDate] [EndDate] [StartTime] [StopTime] [ContractPrice] [CustomerID) [AgentID] [EntertainerID] FROM [EntertainmentAgencyExample] . [dbo] - [Engagements]