[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
ZK (1)