Last weekdays records from date field of MySQL table by dayofweek function

SQL PHP HTML ASP JavaScript articles and free scripts to download

If you are facing any problem in viewing this page, please tell us

Records of the weekdays

Please read the tutorial on last x day's record in part 1 of this tutorial. Here we will develop a query to get records of weekdays of the present week. To get the records we will try by using dayofweek function of MySQL.

This function dayofweek returns values 1 to 7 based on the weekday starting from Sunday as 1, Monday as 2 and …so on for others. So if today is Thursday then dayofweek function will return 5. So we need before three days record ( excluding today ) from today to get the records stating from Monday. So we will deduct 2 from the weekday figure. Here is the query to get the records of all weekdays of a week till today.

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

We have used the same table as sql dump shown in previous section.

List of SQL Tutorials

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

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 last one month from today by using date field

Records of present week days by using dayofweek function

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email	( not to be displayed)Privacy Policy
1+2=	This is to prevent automatic submission by spammers. Please enter the result of the sum as asked

Scripts

PHP

JavaScript

SQL Tutorial List

Date & Time

Date Functions Date Format Date Inserting String to Date Date in varchar field Adding current Date Date Adding Between Dates Getting Date Difference in Days Year of Date Month of Date Day of Date Last 7 Days dayofweek function

SQL Commands

SQL Sections

Date & Time

Join Table

Subscribe

Submit your email address and receive article and product notifications. Your email is safe with us.