Is there a way to select from account where createddate = GetDate. I am looking to only retrieve records from today. 

This query doesn't work in the Source Editor

select * from account where CreatedDate >= CAST(GETDATE() AS DATE)