[MySQL]閒來自己寫的一個日期與秒數的轉換，(FROM_UNIXTIME()，UNIX_TIMESTAMP())
閒來自己寫的一個日期與秒數的轉換

/**
*第一個空白輸入你想轉換的日期，沒輸入則為今天凌晨
*第二個空白輸入你想加的天數，沒輸入則為0 極限值 9523.1345312499
*第三個空白輸入你想減的天數，沒輸入則為0 極限值 15332.00028
*/
SELECT
         t1.todate AS '轉換前日期',
         t1.tosecond AS '轉換前秒數',
         t1.toadd AS '欲加的天數',
         (t1.tosecond+3600*24*t1.toadd) AS '加後的秒數',
         FROM_UNIXTIME(t1.tosecond+3600*24*t1.toadd) AS '加後的日期',
         t1.toreduce AS '欲減的天數',
         (t1.tosecond-3600*24*t1.toreduce) AS '減後的秒數',
         FROM_UNIXTIME(t1.tosecond-3600*24*t1.toreduce) AS '減後的日期'    
FROM
         (SELECT 
                  mydate.todate AS todate,
                  UNIX_TIMESTAMP(mydate.todate) AS tosecond,
                  myadd.toadd AS toadd,
                  myreduce.toreduce AS toreduce
         FROM
                  (SELECT IFNULL(?, curdate()) AS todate) AS mydate,
                  (SELECT IFNULL(?, 0) AS toadd) AS myadd,
                  (SELECT IFNULL(?, 0) AS toreduce) AS myreduce
         )
         AS t1



 
















其它文章

arrow
arrow
    文章標籤
    db sql 用法 程式 測試 目錄 unixtime todate toreduce 天數 轉換 timestamp 則為 閒來 空白
    全站熱搜

    PG Levin Li 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄