https://jackxiang.com/index.php zh-cn https://jackxiang.com/post/7148/ jack <xdy108@126.com> Sun, 20 Apr 2014 09:47:27 +0000 https://jackxiang.com/post/7148/ select count(*) from boblog_blogs;
+-----+
6882
+-----+
select blogid,title,pubtime from boblog_blogs order by  pubtime asc limit 10;
blogid                       title                                                             pubtime  
2                             群殴时总结的技巧                                           1155018983
3                             大学打架手册                                                 1155049193
4                             给大学生的忠告，不是真理，但是足够你用四年    1155049223
6                             黄家驹的歌曲片段                                           1155259448
7                             勤奋不是成功的根本原因                                  1155307410
8                             少走弯路的十大忠告                                        1155307458
9                             如果你是男人，请记住这二十二条忠告                1155307569
10                            华为的笑话：老实人在华为                               1155307651
11                            手表的等级分类                                              1155307701
12                            子网掩码计算方法                                           1155307744
mysql> SELECT FROM_UNIXTIME(1155018983);
+---------------------------+
| FROM_UNIXTIME(1155018983) |
+---------------------------+
| 2006-08-08 14:36:23       |
+---------------------------+
1 row in set (0.01 sec)
感慨良久：2006年8月8日，我的个天，那时还上大学，那时我还上大三，对技术涉及还很少，都是些心灵鸡汤的事，还在考虑是否跨个专业考研还是工作，到现在都8年了，时间真是快啊，但那又怎样，生活还得继续，人生的路还得狂奔不止一路走下去，fight ,come on，加油。
——————————————————————————————————————————————————————————————
MySQL DATETIME类型和Timestamp之间的转换:
参考：http://blog.csdn.net/li_yang98/article/details/5866250
http://jakbb.iteye.com/blog/648332
DATETIME -> Timestamp: UNIX_TIMESTAMP(...)
Timestamp -> DATETIME: FROM_UNIXTIME(...)
mysql> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()));
+--------------------------------------+
| FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())) |
+--------------------------------------+
| 2010-09-06 03:27:41                  |
+--------------------------------------+

mysql> SELECT UNIX_TIMESTAMP() ; （执行使得时间:2009-08-06 10:10:40）
->1249524739
mysql> SELECT UNIX_TIMESTAMP('2009-08-06') ;
->1249488000

mysql>SELECT FROM_UNIXTIME( 1249488000, '%Y%m%d' )  
->20071120
mysql>SELECT FROM_UNIXTIME( 1249488000, '%Y年%m月%d' )  
->2007年11月20
UNIX_TIMESTAMP()是与之相对正好相反的时间函数  
UNIX_TIMESTAMP(), UNIX_TIMESTAMP(date) ]]> https://jackxiang.com/post/7148/#blogcomment63940 呵呵 <artlearn@163.com> Fri, 25 Apr 2014 01:06:36 +0000 https://jackxiang.com/post/7148/#blogcomment63940