02 2014 档案

Python 处理理时间超详细转的
摘要：#-*-coding:utf-8-*-importtimedeftimestamp_datetime(value):format='%Y-%m-%d%H:%M:%S'#value为传入的值为时间戳(整形)，如：1332888820value=time.localtime(value)##经过localtime转换后变成##time.struct_time(tm_year=2012,tm_mon=3,tm_mday=28,tm_hour=6,tm_min=53,tm_sec=40,tm_wday=2,tm_yday=88,tm_isdst=0)#最后再经过strftime函数转换 阅读全文
posted @ 2014-02-25 18:03 jackluo 阅读(535) 评论(0) 推荐(0) 编辑
CentOS 下安装python 之MySQLdb
摘要：yum -y install mysql-devwget http://downloads.sourceforge.net/project/mysql-python/mysql-python-test/1.2.4b4/MySQL-python-1.2.4b4.tar.gz?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fmysql-python%2F&ts=1364895531&use_mirror=nchc tar zxvf MySQL-python-1.2.4b4.tar.gzcd MySQL-python-1.2.4b4python 阅读全文
posted @ 2014-02-21 18:05 jackluo 阅读(21816) 评论(0) 推荐(0) 编辑
mysql中datetime比较大小问题 (转的)
摘要：方法一：你也可以：select * from t1 where unix_timestamp(time1) > unix_timestamp('2011-03-03 17:39:05') and unix_timestamp(time1) = convert(date,表名.datetime列名)三种方法待求证，总之是不要用字符串这么直接比 阅读全文
posted @ 2014-02-12 18:11 jackluo 阅读(3272) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示