Recent data

[teser]

Need to write a query to fetch all projects started in the last day. My field is called 'DateSubmitted'

HOw would I do this in my query??

 

[karluk]

A good start would be

select * from projects
where date_submitted > sysdate-1;