PHP Advanced for the World Wide Web: Visual QuickPro Guide

MySQL Resources

This book had a pretty strong leaning towards using MySQL databases, partly because it is one of the most common applications used with PHP today. Accordingly, here are three tables of MySQL-specific information you might want to have at your fingertips (Tables B.3, B.4, and B.5).

Table B.3. The DATE_FORMAT() function, like the PHP date() function, takes parameters that dictate how the returned string looks.

DATE_FORMAT() Parameters
Term	Result
%a	Weekday as three-letter abbreviation (Sun, Mon…)
%e	Day of the month (1-31)
%h	Hour as two-digits (01, 02…)
%i	Minute as two-digits (01, 02…)
%l	House as one or two-digits (1, 2…)
%M	Month (January, February…)
%p	A.M. or P.M.
%r	Time as HH:MM:SS AM(PM)
%T	Time as HH:MM:SS
%W	Weekday (Sunday, ...