SQL query for events

[<James> <healy>]

Can anyone help with the sql query I could use to see events that occurred
form yesterday to today?