How to get the timestamp of individual records from mysql databse php? -

currently working database , client confused db.

i have table 3 columns named

'fname' | 'lname' | 'email' 

• now have inserted 50 records on 8 april
• i have inserted 30 records , updated 10 record of 8 april on 9 april
• i have inserted 20 records on 10 april

now want fetch records inserted or updated on particular date.

for example: need query such can fetch records play on 9 april.(i.e. 30 inserted records , 10 updated records.). can fetch 40 rows.

i'm not sure how this.

impossible do. need 2 more columns datetime type store created date , updated date