コード例 #1
0
    res = cur.fetchone()
    return res


#start_time = '093800223'
#end_time = '093800551'

#start_time = '94040292'
#end_time = '94040680'

start_time = '093500000'
end_time = '144500000'

## Set the databatesase connection
hangSeng_dbconn = DBConnection.SetDB_HANGSENG()
hangSengMarket_dbconn = DBConnection.SetDB_HANGSENG_MARKET()

## Get  date from Database
#datelist = getAllDates(hangSeng_dbconn)
datelist = ['20170406']

fTime = start_time
lTime = end_time

for i in datelist:
    dst = dt.datetime.now().time().strftime('%H:%M:%S')
    ranDate = i
    s_date = str(i).split("'")
    ranDate = s_date[0]
    print('Date:', ranDate, 'Time:', fTime, '-', lTime)