<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                企業??AI智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                ~~~ SELECT NOW(),CURDATE(),CURTIME() ~~~ |NOW()| CURDATE()| CURTIME()| |----|----|----| |2008-12-29 16:25:46| 2008-12-29 |16:25:46| CURDATE() Returns the current date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in a string or numeric context. ~~~ mysql> SELECT CURDATE(); -> '2008-06-13' mysql> SELECT CURDATE() + 0; -> 20080613 ~~~ #### MySQL CURDATE功能介紹 如果在數字上下文中使用字符串上下文或YYYMMDD格式,CURDATE()函數將以“YYYY-MM-DD”格式的值返回當前日期。 以下示例顯示了如何在字符串上下文中使用CURDATE()函數。 ~~~ sql> SELECT CURDATE(); +------------+ | CURDATE() | +------------+ | 2017-08-10 | +------------+ 1 row in set (0.00 sec) ~~~ 以下示例說明CURDATE()函數如何在數字上下文中使用: ~~~ mysql> SELECT CURDATE() + 0; +---------------+ | CURDATE() + 0 | +---------------+ | 20170810 | +---------------+ 1 row in set ~~~ CURRENT_DATE和CURRENT_DATE()是CURDATE()的同義詞。 ~~~ mysql> SELECT CURRENT_DATE(), CURRENT_DATE, CURDATE(); +----------------+--------------+------------+ | CURRENT_DATE() | CURRENT_DATE | CURDATE() | +----------------+--------------+------------+ | 2017-08-10 | 2017-08-10 | 2017-08-10 | +----------------+--------------+------------+ 1 row in set ~~~ CURDATE與NOW函數 CURDATE()函數只返回當前日期,而NOW()函數返回當前時間的日期和時間部分。CURDATE()函數的結果等同于以下表達式: ~~~ mysql> SELECT DATE(NOW()); +-------------+ | DATE(NOW()) | +-------------+ | 2017-08-10 | +-------------+ 1 row in set ~~~ 在本教程中,您學習了如何使用MySQL CURDATE()函數獲取當前日期值。
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看