SQL Get data for yesterday and day before

In SQL Server you can also try:

MEMBER BETWEEN DATEADD(day, -2, GETDATE()) AND DATEADD(day, -1, GETDATE())

https://stackoverflow.com/questions/18495195/sql-get-data-for-yesterday-and-day-before

CreatedTime AT TIME ZONE 'UTC' AT TIME ZONE 'Pacific Standard Time' >= DATEADD( MONTH, -1, CAST(GETDATE() AS DATETIME) AT TIME ZONE 'Pacific Standard Time' )