SELECT Id, Name FROM Account WHERE CreatedDate = YESTERDAY

To get records created today, use the below query

Sample SOQL:

SELECT Id, Name FROM Account WHERE CreatedDate = TODAY

Cheers!!!