Getting Day Information : Introduction « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. Introduction

There are four functions for converting a date to a day number:

DAYOFYEAR(date)

DAYOFMONTH(date)

DAYOFWEEK(date)

WEEKDAY(date)

DAYOFYEAR(date) returns the day of the year for a given date (in numeric format).

DAYOFYEAR(date) returns how many days since January 1 of that year.

mysql>
mysql> SELECT DAYOFYEAR(20000201);
+---------------------+
| DAYOFYEAR(20000201) |
+---------------------+
|                  32 |
+---------------------+
1 row in set (0.01 sec)








14.1.Introduction
14.1.1.Date and Time Functions
14.1.2.Extraction Functions
14.1.3.Changing Date Values
14.1.4.Getting Day Information
14.1.5.Getting Names for Months and Days
14.1.6.Extracting Years, Quarters, Months, and Weeks
14.1.7.Current Date and Time
14.1.8.Days Since 1 A.D.
14.1.9.Seconds Since the Beginning of the Day