<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>

                ??一站式輕松地調用各大LLM模型接口,支持GPT4、智譜、豆包、星火、月之暗面及文生圖、文生視頻 廣告
                # 函數 隨機數 rand() 連接字符串 concat('中國','打日本') 轉換小寫 lcase('ABC') lower 轉換大寫 upper ucase 去除空格 trim(str) ``` <pre class="calibre14">``` <span class="token1">curdate</span><span class="token2">(</span><span class="token2">)</span><span class="token">+</span><span class="token3">0</span> 返回<span class="token3">20160916</span> <span class="token1">curdate</span><span class="token2">(</span><span class="token2">)</span> <span class="token3">2016</span><span class="token">-</span><span class="token3">09</span><span class="token">-</span><span class="token3">16</span> <span class="token1">curtime</span><span class="token2">(</span><span class="token2">)</span> <span class="token3">21</span><span class="token2">:</span><span class="token3">53</span><span class="token2">:</span><span class="token3">23</span> <span class="token1">now</span><span class="token2">(</span><span class="token2">)</span> <span class="token3">2019</span><span class="token">-</span><span class="token3">07</span><span class="token">-</span><span class="token3">10</span> <span class="token3">21</span><span class="token2">:</span><span class="token3">52</span><span class="token2">:</span><span class="token3">23</span>日期時間 <span class="token1">unix_timestamp</span><span class="token2">(</span><span class="token1">now</span><span class="token2">(</span><span class="token2">)</span><span class="token2">)</span> 返回時間戳 <span class="token3">1562767275</span> <span class="token1">from_unixtime</span><span class="token2">(</span> <span class="token3">1539659520</span><span class="token2">)</span> 返回 <span class="token3">2018</span><span class="token">-</span><span class="token3">10</span><span class="token">-</span><span class="token3">16</span> <span class="token3">11</span><span class="token2">:</span><span class="token3">12</span><span class="token2">:</span><span class="token3">00</span> <span class="token1">from_unixtime</span><span class="token2">(</span><span class="token3">1515980716</span><span class="token2">,</span> <span class="token4">'%Y-%m-%d %H:%i:%S'</span><span class="token2">)</span> <span class="token3">2018</span><span class="token">-</span><span class="token3">01</span><span class="token">-</span><span class="token3">15</span> <span class="token3">09</span><span class="token2">:</span><span class="token3">45</span><span class="token2">:</span><span class="token3">16</span> 格式化時間 <span class="token1">date_format</span><span class="token2">(</span><span class="token1">now</span><span class="token2">(</span><span class="token2">)</span><span class="token2">,</span> <span class="token4">'%Y-%m-%d'</span><span class="token2">)</span> <span class="token3">2018</span><span class="token">-</span><span class="token3">01</span><span class="token">-</span><span class="token3">15</span> <span class="token1">date</span><span class="token2">(</span> <span class="token1">now</span><span class="token2">(</span><span class="token2">)</span><span class="token2">)</span> <span class="token3">2019</span><span class="token">-</span><span class="token3">07</span><span class="token">-</span><span class="token3">10</span> 提取日期 <span class="token1">year</span><span class="token2">(</span><span class="token4">'2019-7-10'</span><span class="token2">)</span> 返回<span class="token3">2019</span> <span class="token1">month</span><span class="token2">(</span><span class="token4">'2016-04-28'</span><span class="token2">)</span> <span class="token3">4</span> <span class="token1">day</span><span class="token2">(</span><span class="token1">now</span><span class="token2">(</span><span class="token2">)</span><span class="token2">)</span> <span class="token3">11</span> 返回天 <span class="token1">hour</span><span class="token2">(</span><span class="token4">'2019-12-6 14:7:50'</span><span class="token2">)</span> <span class="token3">14</span> <span class="token1">minute</span><span class="token2">(</span><span class="token4">'2019-12-6 14:7:50'</span><span class="token2">)</span> <span class="token3">7</span> <span class="token1">second</span><span class="token2">(</span><span class="token4">'2019-12-6 14:7:50'</span><span class="token2">)</span> <span class="token3">50</span> <span class="token1">last_day</span><span class="token2">(</span><span class="token4">'2019-12-6 14:7:50'</span><span class="token2">)</span> <span class="token3">2019</span><span class="token">-</span><span class="token3">12</span><span class="token">-</span><span class="token3">31</span> 給定日期最后一天 <span class="token1">quarter</span><span class="token2">(</span><span class="token4">'2016-04-28'</span><span class="token2">)</span> <span class="token3">2</span> 季度<span class="token2">,</span><span class="token3">1</span><span class="token2">,</span><span class="token3">2</span><span class="token2">,</span><span class="token3">3</span><span class="token2">,</span><span class="token3">4</span> <span class="token1">dayofweek</span><span class="token2">(</span><span class="token4">'2019-7-10'</span><span class="token2">)</span> 返回<span class="token3">4</span> 星期三 <span class="token">-</span><span class="token3">1</span> <span class="token1">weekday</span><span class="token2">(</span><span class="token4">'2019-7-10'</span><span class="token2">)</span> 返回<span class="token3">2</span> 星期三<span class="token">+</span><span class="token3">1</span> <span class="token1">dayofyear</span><span class="token2">(</span><span class="token4">'2019-7-10'</span><span class="token2">)</span> 返回今天是<span class="token3">191</span>天 <span class="token1">to_days</span><span class="token2">(</span><span class="token4">'2019-12-6 14:7:50'</span><span class="token2">)</span> <span class="token3">737764</span>計算日期 d 距離 <span class="token3">0000</span> 年 <span class="token3">1</span> 月 <span class="token3">1</span> 日的天數 <span class="token1">from_days</span><span class="token2">(</span><span class="token3">733627</span><span class="token2">)</span> <span class="token3">2008</span><span class="token">-</span><span class="token3">08</span><span class="token">-</span><span class="token3">08</span> 同上相反 <span class="token1">day</span><span class="token2">(</span><span class="token1">last_day</span><span class="token2">(</span><span class="token1">now</span><span class="token2">(</span><span class="token2">)</span><span class="token2">)</span><span class="token2">)</span> 返回本月天數 <span class="token1">date_add</span><span class="token2">(</span><span class="token4">'2019-12-6 14:7:50'</span><span class="token2">,</span>INTERVAL <span class="token3">1</span> day<span class="token2">)</span> <span class="token">+</span><span class="token3">1</span>天 <span class="token1">date_sub</span><span class="token2">(</span><span class="token4">'2019-12-6 14:7:50'</span><span class="token2">,</span>INTERVAL <span class="token3">1</span> day<span class="token2">)</span> <span class="token">-</span><span class="token3">1</span>天 <span class="token1">timestamp</span><span class="token2">(</span><span class="token4">'2008-08-08'</span><span class="token2">)</span> <span class="token3">2008</span><span class="token">-</span><span class="token3">08</span><span class="token">-</span><span class="token3">08</span> <span class="token3">00</span><span class="token2">:</span><span class="token3">00</span><span class="token2">:</span><span class="token3">00</span> ``` ``` 版本version 聚合函數 avg(col) 平均值 count(\*) 記錄數 min(col) max(col)最小 最大值 sum(col)求和
                  <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>

                              哎呀哎呀视频在线观看