Q&A about the site for users and developers of hardware and software for Raspberry Pi
declare @today datetime declare @yesterday datetime set @today = getdate() set @yesterday = dateadd(day, -1, @today) select @today, @yesterday select count(Id) from Users where CreationDate between @yesterday and @today