{"id":3055,"date":"2016-12-14T10:20:07","date_gmt":"2016-12-14T02:20:07","guid":{"rendered":"http:\/\/ixyzero.com\/blog\/?p=3055"},"modified":"2016-12-14T10:20:07","modified_gmt":"2016-12-14T02:20:07","slug":"shell%e4%b8%ad%e5%a6%82%e4%bd%95%e8%ae%a1%e7%ae%97%e4%b8%a4%e4%b8%aa%e6%97%a5%e6%9c%9f%e4%b9%8b%e9%97%b4%e7%9a%84%e5%a4%a9%e6%95%b0%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/ixyzero.com\/blog\/archives\/3055.html","title":{"rendered":"Shell\u4e2d\u5982\u4f55\u8ba1\u7b97\u4e24\u4e2a\u65e5\u671f\u4e4b\u95f4\u7684\u5929\u6570\uff1f"},"content":{"rendered":"

=Start=<\/p>\n

\u7f18\u7531\uff1a<\/h4>\n

\u5728\u7a0b\u5e8f\u4e2d\u7528\u5230\u548c\u65e5\u671f\u76f8\u5173\u7684\u5faa\u73af\u65f6\uff0c\u53ef\u80fd\u4f1a\u9700\u8981\u63d0\u524d\u786e\u5b9a\u4e24\u4e2a\u65e5\u671f\u4e4b\u95f4\u7684\u5929\u6570\uff1b\u8fd8\u6709\u5c31\u662f\u5728\u65e5\u5e38\u7684\u4e00\u4e9b\u8bb0\u5f55\u4e2d\u4e5f\u4f1a\u60f3\u4e86\u89e3\u4e24\u4e2a\u65e5\u671f\u4e4b\u95f4\u7684\u5929\u6570\uff1b\u603b\u4e4b\uff0c\u8fd9\u6837\u7684\u9700\u6c42\u662f\u5f88\u591a\u7684\u3002<\/p>\n

\u6b63\u6587\uff1a<\/h4>\n

\u53c2\u8003\u89e3\u7b54\uff1a<\/h5>\n

\u4f7f\u7528GNU\u7684date\u547d\u4ee4\uff0c\u5b83\u5141\u8bb8\u4f60\u901a\u8fc7\u300c-d<\/code>\u300d\u9009\u9879\u6307\u5b9a\uff08\u5b83\u80fd\u8bc6\u522b\u7684\uff09\u4efb\u610f\u683c\u5f0f\u7684\u65e5\u671f\uff0c\u7136\u540e\u901a\u8fc7\u300c+%s<\/code>\u300d\u9009\u9879\u5c06\u65e5\u671f\u8f6c\u6362\u6210\u4ece\u300c1970-01-01 00:00:00 UTC\u300d\u4ee5\u6765\u7ecf\u8fc7\u7684\u79d2\u6570\uff0c\u4e24\u8005\u76f8\u51cf\u7136\u540e\u9664\u4ee5\u4e00\u5929\u4e2d\u5305\u542b\u7684\u79d2\u6570\uff0824*60*60=86400\u79d2\uff09\u5373\u53ef\u77e5\u9053\u4e24\u4e2a\u65e5\u671f\u4e4b\u95f4\u76f8\u8ddd\u7684\u5929\u6570\u3002<\/p>\n

\n
\n
\n\n\n\n
\n
\n
datediff() {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>d1=$(date -d\u00a0<\/code>\"$1\"<\/code>\u00a0+%s)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>d2=$(date -d\u00a0<\/code>\"$2\"<\/code>\u00a0+%s)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>echo $(( (d1 - d2) \/\u00a0<\/code>86400<\/code>\u00a0)) days<\/code><\/div>\n
}<\/code><\/div>\n
<\/div>\n
$ datediff\u00a0<\/code>'1 Nov'<\/code>\u00a0'1 Aug'<\/code><\/div>\n
91<\/code>\u00a0days<\/code><\/div>\n
$ datediff\u00a0<\/code>2016<\/code>-<\/code>12<\/code>-<\/code>10<\/code>\u00a02016<\/code>-<\/code>12<\/code>-<\/code>4<\/code><\/div>\n
6<\/code>\u00a0days<\/code><\/div>\n
$ datediff\u00a0<\/code>2016<\/code>-<\/code>12<\/code>-<\/code>10<\/code>\u00a02016<\/code>\/<\/code>12<\/code>\/<\/code>4<\/code><\/div>\n
6<\/code>\u00a0days<\/code><\/div>\n
$ datediff\u00a0<\/code>2016<\/code>-<\/code>12<\/code>-<\/code>4<\/code>\u00a02016<\/code>-<\/code>12<\/code>-<\/code>10<\/code><\/div>\n
-<\/code>6<\/code>\u00a0days<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n

&<\/p>\n

\n
\n
\n\n\n\n
\n
\n
bash-<\/code>4.2<\/code>$ mysql <<<\u00a0<\/code>\"select datediff(current_date,'1980-06-14')\"<\/code><\/div>\n
datediff(current_date,<\/code>'1980-06-14'<\/code>)<\/code><\/div>\n
13332<\/code><\/div>\n
<\/div>\n
bash-<\/code>4.2<\/code>$ psql <<<\u00a0<\/code>\"select current_date-'1980-06-14'\"<\/code><\/div>\n
\u00a0<\/code>?column?<\/code><\/div>\n
----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>13332<\/code><\/div>\n
(<\/code>1<\/code>\u00a0row)<\/code><\/div>\n
<\/div>\n
bash-<\/code>4.2<\/code>$ sqlite2 <<<\u00a0<\/code>\"select julianday('now')-julianday('1980-06-14');\"<\/code><\/div>\n
13332.1524537035<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n

&<\/p>\n

\n
\n
\n\n\n\n
\n
\n
$ echo $(($(($(date -d\u00a0<\/code>\"2010-06-01\"<\/code>\u00a0\"+%s\"<\/code>) - $(date -d\u00a0<\/code>\"2010-05-15\"<\/code>\u00a0\"+%s\"<\/code>))) \/\u00a0<\/code>86400<\/code>))<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n

&<\/p>\n

\n
\n
\n\n\n\n
\n
\n
$ cat > datediff.sh<\/code><\/div>\n
#!\/bin\/bash<\/code><\/div>\n
<\/div>\n
firstdate=$<\/code>1<\/code>;<\/code><\/div>\n
secondate=$<\/code>2<\/code>;<\/code><\/div>\n
<\/div>\n
fullyear=$(date -d@$(( ( $(date -ud\u00a0<\/code>\"$secondate\"<\/code>\u00a0+<\/code>'%s'<\/code>) - $(date -ud\u00a0<\/code>\"$firstdate\"<\/code>\u00a0+<\/code>'%s'<\/code>) ) )) +<\/code>'%Y years %m months %d days %H hours %M minutes %S seconds'<\/code>)<\/code><\/div>\n
yearsubtraction=$(( $(echo $fullyear | sed -r\u00a0<\/code>'s\/^([0-9]+).*\/\\1\/'<\/code>) -\u00a0<\/code>1970<\/code>\u00a0))<\/code><\/div>\n
<\/div>\n
if<\/code>\u00a0[ $yearsubtraction -le\u00a0<\/code>'0'<\/code>\u00a0]; then<\/code><\/div>\n
\u00a0\u00a0<\/code>echo $fullyear | sed -r\u00a0<\/code>\"s\/^([0-9]+) years \/\/\"<\/code><\/div>\n
else<\/code><\/div>\n
\u00a0\u00a0<\/code>echo $fullyear | sed -r\u00a0<\/code>\"s\/^([0-9]+) \/$(printf %02d $yearsubtraction) \/\"<\/code><\/div>\n
fi<\/code><\/div>\n
<\/div>\n
$ chmod +x datediff.sh<\/code><\/div>\n
<\/div>\n
$ .\/datediff.sh\u00a0<\/code>'2013-07-22 11:55:19'<\/code>\u00a0'2015-12-25 02:00:13'<\/code><\/div>\n
02<\/code>\u00a0years\u00a0<\/code>06<\/code>\u00a0months\u00a0<\/code>04<\/code>\u00a0days\u00a0<\/code>16<\/code>\u00a0hours\u00a0<\/code>04<\/code>\u00a0minutes\u00a0<\/code>54<\/code>\u00a0seconds<\/code><\/div>\n
<\/div>\n
$ .\/datediff.sh\u00a0<\/code>'2013-07-22 11:55:19'<\/code>\u00a0'2013-12-25 02:00:13'<\/code><\/div>\n
06<\/code>\u00a0months\u00a0<\/code>05<\/code>\u00a0days\u00a0<\/code>16<\/code>\u00a0hours\u00a0<\/code>04<\/code>\u00a0minutes\u00a0<\/code>54<\/code>\u00a0seconds<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n
\u53c2\u8003\u94fe\u63a5\uff1a<\/h5>\n