SELECT Ad_Format as ListingType,ID,AdminID,'GOLD' AS BillingPlanLevel, Ad_Headline AS Name,Venue AS Location,Primary_Date AS StartDate,Date_Range AS EndDate, Ad_User_Field_1 as 'ReceptionDate',''AS ReceptionTimes,'' AS Description, 'Gallery' AS Type, '' AS Street_Address, City,State, '' AS Zip ,Ad_Target_URL AS URL,Ad_Image as img_Event_Image, '' AS Phone, Primary_Name AS FirstName, '' AS LastName, '' AS MainDomain, '' AS Quote_by_InformedCollector FROM Ad_Units WHERE Ad_Format LIKE 'exb%' AND Ad_Format LIKE '%basic%' AND Ad_Status='Active' AND State = 'Virginia' AND State<>'(Not Specified)' UNION SELECT 'REG' AS ListingType,ID,AdminID,BillingPlanLevel,Name,Location,StartDate,EndDate,CONVERT(Nvarchar(15),ReceptionDate) AS ReceptionDate,ReceptionTimes,CONVERT(Nvarchar(500),Description),Type,Street_Address,City,State,Zip,URL,img_Event_Image,Phone,FirstName,LastName,MainDomain,CONVERT(Nvarchar(500),Quote_by_InformedCollector) AS Quote_by_InformedCollector FROM qry_exhibits_nl WHERE StartDate >= '2023-02-01 00:00:00' AND StartDate <= '2023-03-01 00:00:00' AND State = 'Virginia' AND ISNULL(Country,'')='United States' AND State<>'(Not Specified)' AND nl_type='GALLERY' ORDER BY ListingType, StartDate;
-2147217913
Conversion failed when converting date and/or time from character string.