Using other MySQL date and time functions

Join David Powers for an in-depth discussion in this video Using other MySQL date and time functions, part of PHP Date and Time Essential Training.

Course Overview
Transcript
View Offline
Exercise Files
FAQs

- [Voiceover] MySQL has a large range…of date and time functions…that can help perform useful tasks…without the need for complex sorting or filtering in PHP.…They're all listed here in the MySQL online documentation…with a brief description of what they do,…so let's just scroll down a little bit,…and this one here, DAYNAME, returns the name of the weekday,…and if you click the name of any of these functions,…it takes you directly to an example of how to use it,…so in the case of DAYNAME, you simply pass it the date…as the argument, and it returns the name of the weekday…using the same language as the MySQL server locale,…so for an English setup, it returns Monday,…Tuesday, Wednesday and so on.…

This example shows an actual date being passed…as the argument, but it can also be the name of a column…that stores a date or time stamp,…and then just down here is another one, DAYOFWEEK.…This also takes a date as an argument,…and it returns the weekday index for that date.…Sunday is 1, Monday is 2, and so on.…So we can use these two functions to select records…

Resume Transcript Auto-Scroll

Author

David Powers

Skill Level Intermediate

4h 31m

Duration

72,024

Views

Show More Show Less

Q: How does calculating sunrise and sunset (as shown in chapter 7) work for locations north of the Arctic Circle?

A: In polar regions, date_sun_info() reports the value for sunrise and sunset as 1 on days when the sun never sets. The values are empty for days when the sun never rises.

Related Courses

Introduction
- Welcome
  1m 6s
- What you should know before watching this course
  3m 6s
- Using the exercise files
  3m 10s
1. Handling Dates and Times in PHP
- What's involved in storing dates and time
  1m 27s
- How PHP handles dates and time
  4m 1s
- Setting the default time zone
  8m 37s
2. Basic Date and Time Functions
- Displaying the current date and time
  6m 48s
- Checking that a date is valid
  6m 59s
- Timing how long a script runs
  6m 8s
- Using time() to end a session after a period of inactivity
  7m 31s
- Getting a Unix time stamp for a specific date or time
  5m 13s
- Getting a time stamp from text
  6m 48s
3. Using the DateTime class
- Introducing the DateTime class
  3m 19s
- Creating a DateTime object
  4m 27s
- Displaying the value of a DateTime object
  4m 49s
- Extending DateTime to create a default format
  5m 50s
- Getting the time stamp from a DateTime object
  5m 54s
- Using a time stamp to set the date and time
  5m 8s
- Modifying the time stamp with a date string
  6m 24s
- Troubleshooting incorrect dates
  7m 6s
- Setting the date and time independently
  4m 58s
- Creating a DateTime object from a custom format
  9m 38s
- Comparing DateTime objects
  4m 1s
- Preserving the original date when modifying the time stamp
  4m 50s
4. Working with Time Zones
- Finding the correct time zone from an abbreviation
  3m 58s
- Finding time zones by country
  6m 56s
- Getting the time zone of a DateTime object
  2m 24s
- Creating a DateTime object for a different time zone
  7m 15s
- Changing a DateTime object's time zone
  7m 37s
- Finding the time difference between locations
  7m 10s
- Finding out when the clocks change
  9m 9s
5. Using the DateInterval and DatePeriod classes
- Introducing the DateInterval and DatePeriod classes
  1m 43s
- Creating a DateInterval
  4m 12s
- Adding and subtracting dates
  4m 44s
- Finding the difference between two dates or times
  7m 55s
- Formatting a DateInterval
  5m 32s
- Generating a sequence of dates at regular intervals
  6m 35s
- Finding the third Thursday in each month
  5m 9s
6. Working with ISO Week Dates
- Understanding ISO week dates
  2m 57s
- Creating a DateTime object for an ISO week date
  5m 34s
- Finding the ISO week date
  4m 24s
7. Calculating Sunrise and Sunset
- Finding when the sun rises and sets
  7m 23s
- Getting more information about sunrise and sunset
  2m 46s
- Calculating the number of daylight hours
  5m 12s
8. Dates and Databases
- What's different about how dates are stored?
  3m 42s
- Formatting a date to insert into MySQL/MariaDB
  7m 33s
- Using separate input fields for each date part
  6m 45s
- Using PHP to format a date retrieved from a database
  4m 14s
- Using the MySQL DATE_FORMAT() function
  5m 37s
- Using other MySQL date and time functions
  5m 55s
Conclusion
- Goodbye
  1m 56s

Show MoreShow Less

Take notes with your new membership!

Type in the entry box, then click Enter to save your note.

1:30Press on any video thumbnail to jump immediately to the timecode shown.

Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.

Start Your Free Trial Now

Skills covered in this course

Using other MySQL date and time functions

Author

Updated

Released

Skill Level Intermediate

Duration

Views

Q: How does calculating sunrise and sunset (as shown in chapter 7) work for locations north of the Arctic Circle?

Related Courses

PHP: Accessing Databases with PDO and MySQLi

Code Clinic: PHP

PHP with MySQL Essential Training

PHP: Creating Secure Websites

Introduction

1. Handling Dates and Times in PHP

2. Basic Date and Time Functions

3. Using the DateTime class

4. Working with Time Zones

5. Using the DateInterval and DatePeriod classes

6. Working with ISO Week Dates

7. Calculating Sunrise and Sunset

8. Dates and Databases

Conclusion

Take notes with your new membership!

Skills covered in this course

Continue Assessment

Start Your Free Trial Now