本筆記參考:
1. https://www.w3schools.com/sql/func_mysql_date_format.asp


學習

職場產業

投資理財

<h3 class="draft-block draft--h3" name="header-1kcvo"><span style="font-weight: bold; ">datetime</span> format to <span style="font-weight: bold; ">時分: </span></h3>
<pre class="public-DraftStyleDefault-pre draft-block"><pre class="draft--code-block">DATE_FORMAT("2021-12-21 09:28:37", "%H:%i")</pre></pre>
<div class="draft--imgNormal draft-block"><div><div style="height:508px" class="image-block-prerender" data-src="https://images.vocus.cc/588440ba-fd51-4189-b7f2-bf56da61f62f.png" data-width="508" data-height="499" data-position="center"></div><figcaption class="imageCaption draft-block" style="cursor:text;display:block"></figcaption></div></div>
<div class="draft-block draft--p left"></div>
<div class="draft-block draft--p left"></div>
<div class="draft-block draft--p left"><span style="font-style: italic; ">本筆記參考:<br>1. </span><a href="https://www.w3schools.com/sql/func_mysql_date_format.asp" target="_blank" class="draft--a"><span style="font-style: italic; ">https://www.w3schools.com/sql/func_mysql_date_format.asp</span></a></div>

<h3><strong>datetime</strong> format to <strong>時分:&nbsp;</strong></h3>
<pre><code>DATE_FORMAT("2021-12-21 09:28:37", "%H:%i")</code></pre>
<p><br></p>
<p><br></p>
<p><br></p>
<p><em>本筆記參考:<br>
1. </em><a href="https://www.w3schools.com/sql/func_mysql_date_format.asp"><em>https://www.w3schools.com/sql/func_mysql_date_format.asp</em></a></p>

DATE_FORMAT("2021-12-21 09:28:37", "%H:%i")

本筆記參考:
1. https://www.w3schools.com/sql/func_mysql_date_format.asp

MySQL DATE_FORMAT

datetime format to 時分: