MySQL Cookbook, Second Edition > Working with Dates and Times > Finding the Day of the Week for a Date - Pg. : Safari Books Online

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

MySQL Cookbook, Second Edition

MySQL Cookbook, Second Edition

Search

Contents

Ch. 1. Using the mysql Client Program

Ch. 2. Writing MySQL-Based Programs

Ch. 3. Selecting Data from Tables

Ch. 4. Table Management

Ch. 5. Working with Strings

Ch. 6. Working with Dates and Times

Choosing a Temporal Data Type

Changing MySQL’s Date Format

Setting the Client Time Zone

Determining the Current Date or Time

Using TIMESTAMP to Track Row Modification Times

Extracting Parts of Dates or Times

Synthesizing Dates or Times from Component Values

Converting Between Temporal Data Types and Basic Units

Calculating the Interval Between Two Dates or Times

Adding Date or Time Values

Calculating Ages

Shifting a Date-and-Time Value to a Different Time Zone

Finding the First Day, Last Day, or Length of a Month

Calculating Dates by Substring Replacement

Finding the Day of the Week for a Date

Finding Dates for Any Weekday of a Given Week

Performing Leap Year Calculations

Canonizing Not-Quite-ISO Date Strings

Treating Dates or Times as Numbers

Forcing MySQL to Treat Strings as Temporal Values

Selecting Rows Based on Their Temporal Characteristics

Ch. 7. Sorting Query Results

Ch. 8. Generating Summaries

Ch. 9. Obtaining and Using Metadata

Ch. 10. Importing and Exporting Data

Ch. 11. Generating and Using Sequences

Ch. 12. Using Multiple Tables

Ch. 13. Statistical Techniques

Ch. 14. Handling Duplicates

Ch. 15. Performing Transactions

Ch. 16. Using Stored Routines, Triggers, and Events

Ch. 17. Introduction to MySQL on the Web

Ch. 18. Incorporating Query Results into Web Pages

Ch. 19. Processing Web Input with MySQL

Ch. 20. Using MySQL-Based Web Session Management

Appx. A. Obtaining MySQL Software

Appx. B. Executing Programs from the Command Line

Appx. C. JSP and Tomcat Primer

Appx. D. References

URL

Help

6.16. Finding the Day of the Week for a Date

6.16.1. Problem

You want to know the day of the week on which a date falls.

6.16.2. Solution

Use the DAYNAME⁠(⁠ ⁠ ⁠) function.

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial