{"id":4964,"date":"2012-05-30T11:00:36","date_gmt":"2012-05-30T11:00:36","guid":{"rendered":"http:\/\/phpcodez.com\/?p=4964"},"modified":"2012-05-30T11:00:36","modified_gmt":"2012-05-30T11:00:36","slug":"sql_date_format","status":"publish","type":"post","link":"http:\/\/phpcodez.com\/sql_date_format\/","title":{"rendered":"SQL DATE_FORMAT()"},"content":{"rendered":"

SQL DATE_FORMAT() is used to display date\/time data in different formats.<\/p>\n

Example<\/strong><\/p>\n

mysql> SELECT DATE_FORMAT(NOW(),’%Y-%m-%D’);
\n+——————————-+
\n| DATE_FORMAT(NOW(),’%Y-%m-%D’) |
\n+——————————-+
\n| 2007-05-30th \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|
\n+——————————-+
\n1 row in set (0.00 sec)<\/p>\n

Different formats<\/strong><\/p>\n

%a Abbreviated weekday name
\n%b Abbreviated month name
\n%c Month, numeric
\n%D Day of month with English suffix
\n%d Day of month, numeric (00-31)
\n%e Day of month, numeric (0-31)
\n%f Microseconds
\n%H Hour (00-23)
\n%h Hour (01-12)
\n%I Hour (01-12)
\n%i Minutes, numeric (00-59)
\n%j Day of year (001-366)
\n%k Hour (0-23)
\n%l Hour (1-12)
\n%M Month name
\n%m Month, numeric (00-12)
\n%p AM or PM
\n%r Time, 12-hour (hh:mm:ss AM or PM)
\n%S Seconds (00-59)
\n%s Seconds (00-59)
\n%T Time, 24-hour (hh:mm:ss)
\n%U Week (00-53) where Sunday is the first day of week
\n%u Week (00-53) where Monday is the first day of week
\n%V Week (01-53) where Sunday is the first day of week, used with %X
\n%v Week (01-53) where Monday is the first day of week, used with %x
\n%W Weekday name
\n%w Day of the week (0=Sunday, 6=Saturday)
\n%X Year of the week where Sunday is the first day of week, four digits, used with %V
\n%x Year of the week where Monday is the first day of week, four digits, used with %v
\n%Y Year, four digits
\n%y Year, two digits
\n
\n<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

SQL DATE_FORMAT() is used to display date\/time data in different formats. Example mysql> SELECT DATE_FORMAT(NOW(),’%Y-%m-%D’); +——————————-+ | DATE_FORMAT(NOW(),’%Y-%m-%D’) | +——————————-+ | 2007-05-30th \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| +——————————-+ 1 row in set (0.00 sec) Different formats %a Abbreviated weekday name %b Abbreviated month name %c Month, numeric %D Day of month with English suffix %d Day of month, numeric … Continue reading SQL DATE_FORMAT()<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[213,332,370,392,457,461],"class_list":["post-4964","post","type-post","status-publish","format-standard","hentry","category-sql","tag-functions","tag-mysql","tag-php","tag-query","tag-sql","tag-statement"],"_links":{"self":[{"href":"http:\/\/phpcodez.com\/wp-json\/wp\/v2\/posts\/4964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/phpcodez.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/phpcodez.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/phpcodez.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/phpcodez.com\/wp-json\/wp\/v2\/comments?post=4964"}],"version-history":[{"count":0,"href":"http:\/\/phpcodez.com\/wp-json\/wp\/v2\/posts\/4964\/revisions"}],"wp:attachment":[{"href":"http:\/\/phpcodez.com\/wp-json\/wp\/v2\/media?parent=4964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/phpcodez.com\/wp-json\/wp\/v2\/categories?post=4964"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/phpcodez.com\/wp-json\/wp\/v2\/tags?post=4964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}