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

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                #### MySQL UNIX_TIMESTAMP 函數 unix_timestamp()是把可讀的時間轉換為unix時間戳,這在對datetime存儲的時間進行排序時會用到。如unix_timestamp('2009-08-06 10:10:40'),得到1249524739。如果unix_timestamp()不傳參數,則調用now()函數自動取當前時間。 * * * * * #### 1. 無參數調用:UNIX_TIMESTAMP() ~~~ SELECT UNIX_TIMESTAMP(); 1339123415 ~~~ 返回自'1970-01-01 00:00:00'的到當前時間的秒數差 #### 2. 有參數調用:UNIX_TIMESTAMP(date) `date` 可以是: 1. DATE字符串 2. DATETIME字符串 3. TIMESTAMP 4. 當地時間的YYMMDD 5. YYYMMDD格式的數字 返回自'1970-01-01 00:00:00'與指定時間的秒數差 例子: DATE字符串格式:(日期類型) ~~~ SELECT UNIX_TIMESTAMP(‘2012-06-08’) 1339084800 ~~~ ~~~ SELECT UNIX_TIMESTAMP(CURRENT_DATE()) =>1339084800 注:CURRENT_DATE ()的返回值是一個DATE字符串格式 ~~~ 以下幾種格式返回的結果相同: ~~~ SELECT UNIX_TIMESTAMP('20120608'); SELECT UNIX_TIMESTAMP('2012-6-8'); SELECT UNIX_TIMESTAMP('2012-06-08'); ~~~ 結果都是:1339084800 DATETIME字符串格式:(日期和時間的組合類型) ~~~ SELECT UNIX_TIMESTAMP(‘2012-06-08 10:48:55’) => 1339123415 SELECT UNIX_TIMESTAMP(NOW()) => 1339123415 ~~~ 注:NOW()的返回值是一個DATETIME字符串格式
                  <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>

                              哎呀哎呀视频在线观看