Records of the weekdays

SELECT dt,id,dayofweek(CURDATE()) as c FROM dt_tb WHERE `dt` BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL (dayofweek(CURDATE())-2) DAY ) AND CURDATE( )

Date & Time functions used in Query for MySQL Table Getting formatted date value from date field in MySQL date_add function to calculate date & time of MySQL table Formatting date and time before adding to date field of MySQL String data to Date & time Format by using str_to_date Formatting string data stored in varchar field to date value Automatically updating / inserting current date and time value in a DATETIME field Records of each day by using group by command Collecting records between two date ranges from MySQL table fields Getting date values from MYSQL table in readable format including time Difference in days between two date fields Getting the year part from date field Getting the month part from date field Getting the day part from date field Records of today or records of last X seconds by using curdate() or unix_timestamp Records of last one month from today by using date field Records of present week days by using dayofweek function