python ×Ö·û´®ºÍdatetimeת»»
ΪÁË´Ó×Ö·û´®ÖÐÌáȡʱ¼ä£¬²¢½øÐбȽϣ¬Òò´ËÓÐÁËÕâ¸öÎÊÌ⣬ÈçºÎ½«×Ö·û´®×ª»»³ÉdatetimeÀàÐÍ
1.×Ö·û´®ÓëtimeÀàÐ͵Äת»»
>>> import time
>>> timestr = "time2009-12-14"
>>> t = time.strptime(timestr, "time%Y-%m-%d")
>>> print t
(2009, 12, 14, 0, 0, 0, 0, 348, -1)
>>> type(t)
<type 'time.struct_time'>
>>>
Èç´úÂëËùʾʹÓÃstrptime½øÐÐת»»£¬µÚÒ»¸ö²ÎÊýÊÇҪת»»µÄ×Ö·û´®£¬µÚ¶þ¸ö²ÎÊýÊÇ×Ö·û´®ÖÐʱ¼äµÄ¸ñʽ
ÓëÖ®¶ÔÓ¦µÄÓк¯Êýstrftime£¬Êǽ«timeÀàÐÍת»»ÏàÓ¦µÄ×Ö·û´®
ÏÂÃæÊǸñʽ»¯·ûºÅ»ã×Ü
¡¡¡¡%a ÐÇÆÚ¼¸µÄ¼òд Weekday name, abbr.
¡¡¡¡%A ÐÇÆÚ¼¸µÄÈ«³Æ Weekday name, full
¡¡¡¡%b Ô·ֵļòд Month name, abbr.
¡¡¡¡%B Ô·ݵÄÈ«³Æ Month name, full
¡¡¡¡%c ±ê×¼µÄÈÕÆÚµÄʱ¼ä´® Complete date and time representation
¡¡¡¡%d Ê®½øÖƱíʾµÄÿÔµĵڼ¸Ìì Day of the month
¡¡¡¡%H 24Ð¡Ê±ÖÆµÄСʱ Hour (24-hour clock)
¡¡¡¡%I 12Ð¡Ê±ÖÆµÄСʱ Hour (12-hour clock)
¡¡¡¡%j Ê®½øÖƱíʾµÄÿÄêµÄµÚ¼¸Ìì Day of the year
¡¡¡¡%m Ê®½øÖƱíʾµÄÔÂ·Ý Month number
¡¡¡¡%M Ê®Ê±ÖÆ±íʾµÄ·ÖÖÓÊý Minute number
¡¡¡¡%S Ê®½øÖƵÄÃëÊý Second number
¡¡¡¡%U µÚÄêµÄµÚ¼¸ÖÜ£¬°ÑÐÇÆÚÈÕ×öΪµÚÒ»Ì죨ֵ´Ó0µ½53£©Week number (Sunday first weekday)
¡¡¡¡%w Ê®½øÖƱíʾµÄÐÇÆÚ¼¸£¨Öµ´Ó0µ½6£¬ÐÇÆÚÌìΪ0£©weekday number
¡¡¡¡%W ÿÄêµÄµÚ¼¸ÖÜ£¬°ÑÐÇÆÚÒ»×öΪµÚÒ»Ì죨ֵ´Ó0µ½53£© Week number (Monday first weekday)
¡¡¡¡%x ±ê×¼µÄÈÕÆÚ´® Complete date representation (e.g. 13/01/08)
¡¡¡¡%X ±ê×¼µÄʱ¼ä´® Complete time representation (e.g. 17:02:10)
¡¡¡¡%y ²»´øÊÀ¼ÍµÄÊ®½øÖÆÄê·Ý£¨Öµ´Ó0µ½99£©Year number within century
¡¡¡¡%Y ´øÊÀ¼Í²¿·ÖµÄÊ®ÖÆÄê·Ý Year number
¡¡¡¡%z£¬%Z Ê±ÇøÃû³Æ£¬Èç¹û²»Äܵõ½Ê±ÇøÃû³ÆÔò·µ»Ø¿Õ×Ö·û¡£Name of time zone
¡¡¡¡%% °Ù·ÖºÅ
2.timeÀàÐÍÓëdatetimeÀàÐ͵Äת»»
ÕâÒ»²½±È½Ï¼òµ¥£¬Ê¹ÓÃdatetimeº¯Êý£¬´úÂëÈçÏÂ
>>> import datetime
>>> d = datetime.datetime(* t[:6])
>>> print d
2009-12-14 00:00:00
>>> type(d)
<type 'datetim
Ïà¹ØÎĵµ£º
import pymssql
#connect database
conn=pymssql.connect(host="192.168.1.28",user="boomink",password="boomink",
database="boomink")
cur=conn.cursor()
print '========================================'
cur.execute("exec Orders_GetTest1 @Valu ......
Îļþ²Ù×÷ÊdzÌÐòÉè¼ÆÖв»¿É»òȱµÄÖØÒª²¿·Ö¡£Pythonͨ¹ýÒ»¸öÄÚÖú¯ÊýopenÀ´´ò¿ªÎļþ¡£
open(filename,mode,buffer)
ÆäÖеÚÒ»¸ö²ÎÊýÊÇÒª´ò¿ªµÄÎļþµÄÎļþÃû£¬±ØÑ¡£»µÚ¶þ¸öÊÇ´ò¿ª·½Ê½£¬¿ÉÑ¡£»µÚÈý¸öΪ»º³åÇø£¬¿ÉÑ¡¡£Ä¬ÈÏÇé¿öÏÂÊÇÒÔ“¶Á”ģʽ´ò¿ªÎļþ¡£¸Ãº¯Êý ......
×÷Ϊһ¸ö³õѧshellµÄ³ÌÐòÔ±À´Ëµ£¬Ê¹ÓÃshellµÄһЩÃüÁîµ÷Ó㬱ÈÈç¾Íд¼¸ÐУ¬×öһЩ×Ô¶¯»¯µÄ²Ù×÷£¬¼òµ¥ÓÖʵÓ㬵«ÊÇÉæ¼°Âß¼¿ØÖƺÍ
×Ö·û´®´¦Àíʱ£¬¿´µ½ÄÇif/fi£¬case£¯esac……»¹ÓйÅÀë¹Å¹ÖµÄ²¼¶ûÅжυ…»¹Óи´ÔÓ¶øÓÖÃû×ÖºÜÏì¶øÇÒºÜÀÏ×ʸñµÄsed¡¢awk……ÎÒ¾ÍÏ룬
ÔÚûÓзÇÒªÔÚshellÖÐ ......
http://sourceforge.net/projects/pyexcelerator/
12ÔÂ2ÈÕ
python ¶ÁдExcelÎļþ£¨×ªÌû limodou£©
http://www.lexicon.net/sjmachin/xlrd.htm
Õâ¸ö°üÊÇÓÃÀ´¶ÁExcelÎļþµÄ
ÔÚ·¢ÏÖ xlrd Ö®ºó²»¾Ã¾Í·¢ÏÖÁË pyExcelerator
£¬ËüÓë xlrd ²»Í¬£¬ËüÖ÷ÒªÊÇÓÃÀ´Ð´ Excel Îļþ£¬µ±È»¶ÁÒ²ÊÇûÓÐÎÊÌâµÄ¡£ÏÂÃæ¾ÍËüµÄʹÓüòµ¥µØ½éÉ ......