declare @today datetime declare @yesterday datetime set ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Raspberry Pi Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results