blocks|key|2110228|text|有很多方法可以做到这一点：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2110229|2110230|和MySQL，使用DATE_FORMAT+date('J,+M+d+Y',+strtotime($yourdate))|unordered-list-item|offset|length|style|CODE|2110231|With+PHP，使用strtotime和date：date+=+moment("2012-04-12",+"DDDD,+MMMM+DD+YYYY");.|2110232|+|2110233|，在"-“处拆分日期，然后使用t0s6i重新创建日期(就像t0s6i解释的那样)，使用JavaScript，您可以使用库momentjs来执行以下操作：|2110234|2110235|entityMap|0|LINK|mutability|MUTABLE|url|http://momentjs.com/^0|0|0|9|B|L|12|0|B|9|L|4|Q|1E|0|0|1O|8|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|10|8|@$F|11|G|12|H|I]|$F|13|G|14|H|I]]|9|@]|A|$]]|$1|J|3|K|5|E|7|15|8|@$F|16|G|17|H|I]|$F|18|G|19|H|I]|$F|1A|G|1B|H|I]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1C|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|1D|8|@]|9|@$F|1E|G|1F|1|1G]]|A|$]]|$1|P|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

You have a lot of ways to do this:

<ul>
<li>With MySQL, using <code>DATE_FORMAT</code> <a href="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format" rel="nofollow">http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format</a></li>
<li>With PHP, using <code>strtotime</code> and <code>date</code>: <code>date('J, M d Y', strtotime($yourdate))</code></li>
<li>With JavaScript, splitting the date at "-" and then creating your date again with <code>new Date()</code></li>
<li>Also (like explained by t0s6i), with JavaScript, you can use the library <a href="http://momentjs.com" rel="nofollow">momentjs</a> to do something like this: <code>date = moment("2012-04-12", "DDDD, MMMM DD YYYY");</code>.</li>
</ul>

blocks|key|1725618|text|试试moment.js|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1725619|例如，var+day+=+moment("2012-04-12"，"DDDD，MMMM+DD+YYYY")；|1725620|entityMap|0|LINK|mutability|MUTABLE|url|http://momentjs.com/^0|2|9|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

Try <a href="http://momentjs.com/" rel="nofollow">moment.js</a>

e.g. var day = moment("2012-04-12", "DDDD, MMMM DD YYYY");

blocks|key|1725467|text|要使用jquery在javascript中进行格式化，请在这篇文章中进行loo。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1725468|Best+JavaScript+Date+Parser+&+Formatter?|offset|length|1725469|我可能会使用实际拉出日期表单MySql的代码进行格式化。你用的是什么语言？php、asp、java...？|1725470|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/206790/best-javascript-date-parser-formatter^0|0|0|14|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

For formatting in javascript using jquery, loo at this other post.

<a href="https://stackoverflow.com/questions/206790/best-javascript-date-parser-formatter">Best JavaScript Date Parser &amp; Formatter?</a>

I would probably format with the code actually pulling the date form MySql.
What language are you using? php, asp, java...?

blocks|key|2115426|text|PHP有一个方便的类，用于读取特定格式的日期：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2115427|http://www.php.net/manual/en/datetime.createfromformat.php|offset|length|2115428|$result+=+mysql_query("select+date_column+from+table_name+limit+1");
$array+=+mysql_fetch_array($result);

print+DateTime::createFromFormat('Y-m-d')->format('jS+M+Y');|code-block|syntax|javascript|2115429|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1M|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|H|7|W|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|C]]]]

PHP has a convenient class for reading dates in a specific format:

<a href="http://www.php.net/manual/en/datetime.createfromformat.php" rel="nofollow">http://www.php.net/manual/en/datetime.createfromformat.php</a>

<pre><code>$result = mysql_query("select date_column from table_name limit 1");
$array = mysql_fetch_array($result);

print DateTime::createFromFormat('Y-m-d')-&gt;format('jS M Y');
</code></pre>

blocks|key|1725515|text|最好的方法通常是在输出之前使用PHP端设置值的格式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1725516|$date+=+DateTime::createFromFormat('Y-m-d',+$row['the_date']);
echo+$date->format('J,+M+d+Y');|code-block|syntax|javascript|1725517|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The best approach is usually to format the value with the PHP side just before outputting it:

<pre><code>$date = DateTime::createFromFormat('Y-m-d', $row['the_date']);
echo $date-&gt;format('J, M d Y');
</code></pre>

blocks|key|2115470|text|当你有一个日期与mysql，它是你收到它的Php不？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2115471|为了优化你的性能，使用原生的php+date函数来转换你的mysql日期，这很简单：|2115472|只需阅读官方PHP文档=>+http://php.net/manual/fr/function.date.php|offset|length|2115473|Php处理比javascript处理更快。|2115474|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/fr/function.date.php^0|0|0|E|16|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$F|U|G|V|1|W]]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

When you have an date with mysql, it's you receive it in Php no? 

for optimize your performance, use the native php date function to convert your mysql date , it's easy: 

read just the official PHP doc => <a href="http://php.net/manual/fr/function.date.php" rel="nofollow">http://php.net/manual/fr/function.date.php</a>

Php treatments as more fast than javascript treatments.

blocks|key|1725576|text|在javascript中，您可以使用下面的函数设置日期的格式|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1725577|注意：下面的函数另外显示日期的sup+(例如:3号，12号e.t.c)。如果您不需要，请删除以下代码中的所有if..else+if。|offset|length|style|BOLD|CODE|1725578|function+formatDate(d)+{

++++var+d_names+=+new+Array("Sunday",+"Monday",+"Tuesday",+"Wednesday",+"Thursday",+"Friday",+"Saturday");

++++var+m_names+=+new+Array("January",+"February",+"March",+"April",+"May",+"June",+"July",+"August",+"September",+"October",+"November",+"December");

++++var+curr_day+=+d.getDay();
++++var+curr_date+=+d.getDate();
++++var+sup+=+"";
++++if+(curr_date+==+1+%7C%7C+curr_date+==+21+%7C%7C+curr_date+==+31)+{
++++++++sup+=+"st";
++++}+else+if+(curr_date+==+2+%7C%7C+curr_date+==+22)+{
++++++++sup+=+"nd";
++++}+else+if+(curr_date+==+3+%7C%7C+curr_date+==+23)+{
++++++++sup+=+"rd";
++++}+else+{
++++++++sup+=+"th";
++++}

++++var+curr_month+=+d.getMonth();
++++var+curr_year+=+d.getFullYear();

++++return++d_names[curr_day]+%2B+"+"+%2B+m_names[curr_month]+%2B+"+"+%2B+curr_date+%2B+sup+%2B+"++"+%2B+curr_year;

}|code-block|syntax|javascript|1725579|参考：+Javascript+Date+formatting+(上面是Format+#5的修改版本)|1725580|entityMap|0|LINK|mutability|MUTABLE|url|http://www.webdevelopersnotes.com/tips/html/getting_current_time_using_javascript.php3^0|0|0|3|1I|B|0|0|0|3|4|Q|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@$D|Z|E|10|F|G]|$D|11|E|12|F|H]]|9|@]|A|$]]|$1|I|3|J|5|K|7|13|8|@]|9|@]|A|$L|M]]|$1|N|3|O|5|6|7|14|8|@$D|15|E|16|F|G]]|9|@$D|17|E|18|1|19]]|A|$]]|$1|P|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|W]]]]

From javascript you can format your date using below function, <a href="http://jsfiddle.net/CZqTJ/1/" rel="nofollow">DEMO</a>

Note: The below function additionally displays sup for date (ex: 3rd, 12th e.t.c). Remove all the <code>if..else if</code> in below code if you don't want it.

<pre><code>function formatDate(d) {

 var d_names = new Array("Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday");

 var m_names = new Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");

 var curr_day = d.getDay();
 var curr_date = d.getDate();
 var sup = "";
 if (curr_date == 1 || curr_date == 21 || curr_date == 31) {
 sup = "st";
 } else if (curr_date == 2 || curr_date == 22) {
 sup = "nd";
 } else if (curr_date == 3 || curr_date == 23) {
 sup = "rd";
 } else {
 sup = "th";
 }

 var curr_month = d.getMonth();
 var curr_year = d.getFullYear();

 return d_names[curr_day] + " " + m_names[curr_month] + " " + curr_date + sup + " " + curr_year;

}
</code></pre>

Reference: <a href="http://www.webdevelopersnotes.com/tips/html/getting_current_time_using_javascript.php3" rel="nofollow">Javascript Date formatting</a> (above is modified version of Format #5)

I have the following date format in a MySQL database and was wondering what would be the best method to reformat this date and output what I have in mind.

MySQL: 2012-04-12

Desired Output: Thursday, April 12 2012

Perhaps I could format it in the MySQL query?
Or with Java script?

Could anyone provide a sample of both so I could learn?

JQuery format date from MySQL. How?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我在MySQL数据库中有以下日期格式，我想知道重新格式化这个日期并输出我想要的内容的最好方法是什么。MySQL: 2012-04-12所需输出: 2012年4月12日星期四也许我可以在MySQL查询中对其进行格式化？还是使用Java script？有没有人能提供这两个的样本，以便我可以学习？

问来自MySQL的JQuery格式日期。多么?
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问来自MySQL的JQuery格式日期。多么?EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问来自MySQL的JQuery格式日期。多么?
EN