if (endTime == defaultDate) endTime = DateTime.MaxValue; >sqlStatement.AppendLine("salespoint = @SalesPoint AND date_time between @StartTime and @EndTime"); >sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime; >sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;or will it be less efficient on the SQL side ?