Sherzy
10/23/2019 - 10:26 PM

Select rows by datetime

SELECT        OrgTaskId, OrgId, Scheduled, TaskType, Name, Value, NotifyBody, RunAt, StartedAt, CompletedAt, Progress, Details, Status, Created, CreatedBy, Updated, UpdatedBy
FROM            OrgTask
WHERE        (Status = 'NS') AND (TaskType = 54) AND (DATEPART(HOUR, RunAt) = 7)