{"id":171,"date":"2011-06-02T20:09:09","date_gmt":"2011-06-02T20:09:09","guid":{"rendered":"a4a042cf4fd6bfb47701cbc8a1653ada"},"modified":"2011-06-02T20:09:09","modified_gmt":"2011-06-02T20:09:09","slug":"","status":"publish","type":"post","link":"https:\/\/www.xiaobo.li\/notes\/archives\/171","title":{"rendered":"mysql\u4e0ephp\u65f6\u95f4\u683c\u5f0f\u5316\u53c2\u6570\u53c2\u8003"},"content":{"rendered":"

\u4e3a\u65b9\u4fbf\u67e5\u9605\uff0c\u4ece\u5b98\u65b9\u7f51\u7ad9\u4e0a\u8f6c\u8f7d\u7684\u3002\u56e0\u4e3amysql\u8fd8\u6709php\u7684\u65f6\u95f4\u683c\u5f0f\u5316\u53c2\u6570\u4e0d\u540c\uff0c\u4e0d\u5c0f\u5fc3\u4f1a\u641e\u6df7\uff0c\u8fd9\u91cc\u6574\u7406\u4e00\u756a<\/p>\n

PHP<\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
format<\/tt><\/em> character<\/th>\nDescription<\/th>\nExample returned values<\/th>\n<\/tr>\n<\/thead>\n
Day<\/em><\/td>\n\u2014<\/td>\n\u2014<\/td>\n<\/tr>\n
d<\/em><\/td>\nDay of the month, 2 digits with leading zeros<\/td>\n01<\/em> to 31<\/em><\/td>\n<\/tr>\n
D<\/em><\/td>\nA textual representation of a day, three letters<\/td>\nMon<\/em> through Sun<\/em><\/td>\n<\/tr>\n
j<\/em><\/td>\nDay of the month without leading zeros<\/td>\n1<\/em> to 31<\/em><\/td>\n<\/tr>\n
l<\/em> (lowercase \u2018L\u2019)<\/td>\nA full textual representation of the day of the week<\/td>\nSunday<\/em> through Saturday<\/em><\/td>\n<\/tr>\n
N<\/em><\/td>\nISO-8601 numeric representation of the day of the week (added in PHP 5.1.0)<\/td>\n1<\/em> (for Monday) through 7<\/em> (for Sunday)<\/td>\n<\/tr>\n
S<\/em><\/td>\nEnglish ordinal suffix for the day of the month, 2 characters<\/td>\nst<\/em>, nd<\/em>, rd<\/em> or th<\/em>. Works well with j<\/em><\/td>\n<\/tr>\n
w<\/em><\/td>\nNumeric representation of the day of the week<\/td>\n0<\/em> (for Sunday) through 6<\/em> (for Saturday)<\/td>\n<\/tr>\n
z<\/em><\/td>\nThe day of the year (starting from 0)<\/td>\n0<\/em> through 365<\/em><\/td>\n<\/tr>\n
Week<\/em><\/td>\n\u2014<\/td>\n\u2014<\/td>\n<\/tr>\n
W<\/em><\/td>\nISO-8601 week number of year, weeks starting on Monday (added in PHP 4.1.0)<\/td>\nExample: 42<\/em> (the 42nd week in the year)<\/td>\n<\/tr>\n
Month<\/em><\/td>\n\u2014<\/td>\n\u2014<\/td>\n<\/tr>\n
F<\/em><\/td>\nA full textual representation of a month, such as January or March<\/td>\nJanuary<\/em> through December<\/em><\/td>\n<\/tr>\n
m<\/em><\/td>\nNumeric representation of a month, with leading zeros<\/td>\n01<\/em> through 12<\/em><\/td>\n<\/tr>\n
M<\/em><\/td>\nA short textual representation of a month, three letters<\/td>\nJan<\/em> through Dec<\/em><\/td>\n<\/tr>\n
n<\/em><\/td>\nNumeric representation of a month, without leading zeros<\/td>\n1<\/em> through 12<\/em><\/td>\n<\/tr>\n
t<\/em><\/td>\nNumber of days in the given month<\/td>\n28<\/em> through 31<\/em><\/td>\n<\/tr>\n
Year<\/em><\/td>\n\u2014<\/td>\n\u2014<\/td>\n<\/tr>\n
L<\/em><\/td>\nWhether it\u2019s a leap year<\/td>\n1<\/em> if it is a leap year, 0<\/em> otherwise.<\/td>\n<\/tr>\n
o<\/em><\/td>\nISO-8601 year number. This has the same value as Y<\/em>, except that if the ISO week number (W<\/em>) belongs to the previous or next year, that year is used instead. (added in PHP 5.1.0)<\/td>\nExamples: 1999<\/em> or 2003<\/em><\/td>\n<\/tr>\n
Y<\/em><\/td>\nA full numeric representation of a year, 4 digits<\/td>\nExamples: 1999<\/em> or 2003<\/em><\/td>\n<\/tr>\n
y<\/em><\/td>\nA two digit representation of a year<\/td>\nExamples: 99<\/em> or 03<\/em><\/td>\n<\/tr>\n
Time<\/em><\/td>\n\u2014<\/td>\n\u2014<\/td>\n<\/tr>\n
a<\/em><\/td>\nLowercase Ante meridiem and Post meridiem<\/td>\nam<\/em> or pm<\/em><\/td>\n<\/tr>\n
A<\/em><\/td>\nUppercase Ante meridiem and Post meridiem<\/td>\nAM<\/em> or PM<\/em><\/td>\n<\/tr>\n
B<\/em><\/td>\nSwatch Internet time<\/td>\n000<\/em> through 999<\/em><\/td>\n<\/tr>\n
g<\/em><\/td>\n12-hour format of an hour without leading zeros<\/td>\n1<\/em> through 12<\/em><\/td>\n<\/tr>\n
G<\/em><\/td>\n24-hour format of an hour without leading zeros<\/td>\n0<\/em> through 23<\/em><\/td>\n<\/tr>\n
h<\/em><\/td>\n12-hour format of an hour with leading zeros<\/td>\n01<\/em> through 12<\/em><\/td>\n<\/tr>\n
H<\/em><\/td>\n24-hour format of an hour with leading zeros<\/td>\n00<\/em> through 23<\/em><\/td>\n<\/tr>\n
i<\/em><\/td>\nMinutes with leading zeros<\/td>\n00<\/em> to 59<\/em><\/td>\n<\/tr>\n
s<\/em><\/td>\nSeconds, with leading zeros<\/td>\n00<\/em> through 59<\/em><\/td>\n<\/tr>\n
u<\/em><\/td>\nMicroseconds (added in PHP 5.2.2)<\/td>\nExample: 654321<\/em><\/td>\n<\/tr>\n
Timezone<\/em><\/td>\n\u2014<\/td>\n\u2014<\/td>\n<\/tr>\n
e<\/em><\/td>\nTimezone identifier (added in PHP 5.1.0)<\/td>\nExamples: UTC<\/em>, GMT<\/em>, Atlantic\/Azores<\/em><\/td>\n<\/tr>\n
I<\/em> (capital i)<\/td>\nWhether or not the date is in daylight saving time<\/td>\n1<\/em> if Daylight Saving Time, 0<\/em> otherwise.<\/td>\n<\/tr>\n
O<\/em><\/td>\nDifference to Greenwich time (GMT) in hours<\/td>\nExample: +0200<\/em><\/td>\n<\/tr>\n
P<\/em><\/td>\nDifference to Greenwich time (GMT) with colon between hours and minutes (added in PHP 5.1.3)<\/td>\nExample: +02:00<\/em><\/td>\n<\/tr>\n
T<\/em><\/td>\nTimezone abbreviation<\/td>\nExamples: EST<\/em>, MDT<\/em> \u2026<\/td>\n<\/tr>\n
Z<\/em><\/td>\nTimezone offset in seconds. The offset for timezones
\nwest of UTC is always negative, and for those east of UTC is
\nalways positive.<\/td>\n		-43200<\/em> through 50400<\/em><\/td>\n<\/tr>\n
Full Date\/Time<\/em><\/td>\n\u2014<\/td>\n\u2014<\/td>\n<\/tr>\n
c<\/em><\/td>\nISO 8601 date (added in PHP 5)<\/td>\n2004-02-12T15:19:21+00:00<\/td>\n<\/tr>\n
r<\/em><\/td>\n\u00bb RFC 2822<\/a> formatted date<\/td>\nExample: Thu, 21 Dec 2000 16:01:07 +0200<\/em><\/td>\n<\/tr>\n
U<\/em><\/td>\nSeconds since the Unix Epoch (January 1 1970 00:00:00 GMT)<\/td>\nSee also time()<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Unrecognized characters in the format string will be printed as-is. The Z<\/em> format will always return 0<\/em> when using gmdate()<\/a>.<\/p>\n

Note<\/strong>: Since this function only accepts integer<\/a> timestamps the u<\/em> format character is only useful when using the date_format()<\/a> function with user based timestamps created with date_create()<\/a>.<\/p>\n

MySQL<\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Specifier<\/th>\nDescription<\/th>\n<\/tr>\n
%a<\/code><\/td>\nAbbreviated weekday name (Sun<\/code>..Sat<\/code>)<\/td>\n<\/tr>\n
%b<\/code><\/td>\nAbbreviated month name (Jan<\/code>..Dec<\/code>)<\/td>\n<\/tr>\n
%c<\/code><\/td>\nMonth, numeric (0<\/code>..12<\/code>)<\/td>\n<\/tr>\n
%D<\/code><\/td>\nDay of the month with English suffix (0th<\/code>, 1st<\/code>, 2nd<\/code>, 3rd<\/code>, \u2026)<\/td>\n<\/tr>\n
%d<\/code><\/td>\nDay of the month, numeric (00<\/code>..31<\/code>)<\/td>\n<\/tr>\n
%e<\/code><\/td>\nDay of the month, numeric (0<\/code>..31<\/code>)<\/td>\n<\/tr>\n
%f<\/code><\/td>\nMicroseconds (000000<\/code>..999999<\/code>)<\/td>\n<\/tr>\n
%H<\/code><\/td>\nHour (00<\/code>..23<\/code>)<\/td>\n<\/tr>\n
%h<\/code><\/td>\nHour (01<\/code>..12<\/code>)<\/td>\n<\/tr>\n
%I<\/code><\/td>\nHour (01<\/code>..12<\/code>)<\/td>\n<\/tr>\n
%i<\/code><\/td>\nMinutes, numeric (00<\/code>..59<\/code>)<\/td>\n<\/tr>\n
%j<\/code><\/td>\nDay of year (001<\/code>..366<\/code>)<\/td>\n<\/tr>\n
%k<\/code><\/td>\nHour (0<\/code>..23<\/code>)<\/td>\n<\/tr>\n
%l<\/code><\/td>\nHour (1<\/code>..12<\/code>)<\/td>\n<\/tr>\n
%M<\/code><\/td>\nMonth name (January<\/code>..December<\/code>)<\/td>\n<\/tr>\n
%m<\/code><\/td>\nMonth, numeric (00<\/code>..12<\/code>)<\/td>\n<\/tr>\n
%p<\/code><\/td>\nAM<\/code> or PM<\/code><\/td>\n<\/tr>\n
%r<\/code><\/td>\nTime, 12-hour (hh:mm:ss<\/code> followed by AM<\/code> or PM<\/code>)<\/td>\n<\/tr>\n
%S<\/code><\/td>\nSeconds (00<\/code>..59<\/code>)<\/td>\n<\/tr>\n
%s<\/code><\/td>\nSeconds (00<\/code>..59<\/code>)<\/td>\n<\/tr>\n
%T<\/code><\/td>\nTime, 24-hour (hh:mm:ss<\/code>)<\/td>\n<\/tr>\n
%U<\/code><\/td>\nWeek (00<\/code>..53<\/code>), where Sunday is the first day of the week<\/td>\n<\/tr>\n
%u<\/code><\/td>\nWeek (00<\/code>..53<\/code>), where Monday is the first day of the week<\/td>\n<\/tr>\n
%V<\/code><\/td>\nWeek (01<\/code>..53<\/code>), where Sunday is the first day of the week; used with %X<\/code><\/td>\n<\/tr>\n
%v<\/code><\/td>\nWeek (01<\/code>..53<\/code>), where Monday is the first day of the week; used with %x<\/code><\/td>\n<\/tr>\n
%W<\/code><\/td>\nWeekday name (Sunday<\/code>..Saturday<\/code>)<\/td>\n<\/tr>\n
%w<\/code><\/td>\nDay of the week (0<\/code>=Sunday..6<\/code>=Saturday)<\/td>\n<\/tr>\n
%X<\/code><\/td>\nYear for the week where Sunday is the first day of the week, numeric, four digits; used with %V<\/code><\/td>\n<\/tr>\n
%x<\/code><\/td>\nYear for the week, where Monday is the first day of the week, numeric, four digits; used with %v<\/code><\/td>\n<\/tr>\n
%Y<\/code><\/td>\nYear, numeric, four digits<\/td>\n<\/tr>\n
%y<\/code><\/td>\nYear, numeric (two digits)<\/td>\n<\/tr>\n
%%<\/code><\/td>\nA literal \u201c%<\/code>\u201d character<\/td>\n<\/tr>\n
%x<\/code><\/em><\/code><\/td>\nx<\/code><\/em>, for any \u201cx<\/code><\/em>\u201d not listed above<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

\u4e3a\u65b9\u4fbf\u67e5\u9605\uff0c\u4ece\u5b98\u65b9\u7f51\u7ad9\u4e0a\u8f6c\u8f7d\u7684\u3002\u56e0\u4e3amysql\u8fd8\u6709php\u7684\u65f6\u95f4\u683c\u5f0f\u5316\u53c2\u6570\u4e0d\u540c\uff0c\u4e0d\u5c0f\u5fc3\u4f1a\u641e\u6df7\uff0c\u8fd9\u91cc\u6574\u7406\u4e00\u756a<\/p>\n

PHP<\/h3>\n\n\n\n\n\n\n\n\n\n
format<\/tt><\/em> character<\/th>\nDescription<\/th>\nExample returned values<\/th>\n<\/tr>\n<\/thead>\n
Day<\/em><\/td>\n\u2014<\/td>\n\u2014<\/td>\n<\/tr>\n
d<\/em><\/td>\nDay of the month, 2 digits with leading zeros<\/td>\n01<\/em> to 31<\/em><\/td>\n<\/tr>\n
D<\/em><\/td>\nA textual representation of a day, three letters<\/td>\nMon<\/em> through Sun<\/em><\/td>\n<\/tr>\n
j<\/em><\/td>\nDay of the month without leading zeros<\/td>\n1<\/em> to 31<\/em><\/td>\n<\/tr>\n
l<\/em> (lowercase \u2018L\u2019)<\/td>\nA full ...<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[288],"tags":[2],"class_list":["post-171","post","type-post","status-publish","format-standard","hentry","category-db","tag-MySQL"],"_links":{"self":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts\/171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/comments?post=171"}],"version-history":[{"count":0,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts\/171\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/media?parent=171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/categories?post=171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/tags?post=171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}