python - Trouble comparing datetime objects -


i have python application logging successes , fails of try block in database. use dateime.timedelta in script calculate datetime.datetime.now minus 5 minutes. later use datetime.datetime.strptime(last_time, "%m/%d/%y %h:%m:%s %p") convert unicode timestamp date. lastly, compare last_run , now_minus_5 variables. script below;

i not receive output conditional statement should true.

start = datetime.datetime.now()     = 5     i2= 10     now_minus_5 = start - datetime.timedelta(minutes =i)     now_minus_10 = start - datetime.timedelta(minutes =i2)  order_fld =  "time"         return_flds = ["time", "success"]         where_str = """time >=  dateadd(minute, -5,  getdate()) , success = 'no'"""         sql_clause = (none,'order {} desc'.format(order_fld))         last_row = ''         arcpy.da.searchcursor(atable, return_flds, where_clause=where_str, sql_clause=sql_clause) cursor:             last_row = cursor.next()             last_time = last_row[0]             last_run = datetime.datetime.strptime(last_time,"%m/%d/%y %h:%m:%s %p")             last_success = last_row[1]              print last_run             print last_success              if last_run >= now_minus_5:                 print "true"`

the issue you're seeing because of incorrect inputs strptime().

referencing python docs on strftime , strptime behavior, notes column %p refers notes 1 , 2. specific situation note 2, "when used strptime() method, %p directive affects output hour field if %i directive used parse hour."

updating strptime call fixes invalid behavior:

>>> import datetime >>> last_time = u'4/24/2015 4:34:10 pm' >>> last_run = datetime.datetime.strptime(last_time,"%m/%d/%y %h:%m:%s %p") >>> last_run datetime.datetime(2015, 4, 24, 4, 34, 10) >>> last_run = datetime.datetime.strptime(last_time,"%m/%d/%y %i:%m:%s %p") >>> last_run datetime.datetime(2015, 4, 24, 16, 34, 10)

Comments

Post a Comment

Popular posts from this blog

shopping cart - Page redirect not working PHP -

im trying redirect user when click "empty cart". redirect working "add cart" not "empty cart". ideas great. in main .php file set current url seen $current_url = base64_encode("http://$_server[http_host]$_server[request_uri]"); then below cartaction.php file handles actions such "add cart" , "empty cart" <?php session_start(); include_once 'config.php'; //add item in shopping cart if(isset($_post["add"])) { $product_id = $_post["product_id"]; //product id $return_url = base64_decode($_post["return_url"]); //return url $qty = $_post["qty"]; $product = $mysqli->query("select product_name, unit_price, unit_quantity products product_id = '$product_id'"); $obj = $product->fetch_object(); if(!isset($_session['products'])) { $_session['products'] = array(); } if(array_key_exists($product_id...
Read more

php - How to modify a menu to show sub-menus -

i have custom php menu made person, displays categories menu. however, need display subcategories well. tried adding hierarchical parameter didn't work. hoping assistance! here code: <ul> <?php /* categories wp e-commerce products */ $wpec_product_categories = get_terms( 'wpsc_product_category', 'hide_empty=0&parent=0&exclude=298'); $myarray = array(); foreach($wpec_product_categories $wpec_categories){ $myarray[$wpec_categories->term_id]['name'] = $wpec_categories->name; $myarray[$wpec_categories->term_id]['slug'] = $wpec_categories->slug; $myarray[$wpec_categories->term_id]['term_id'] = $wpec_categories->term_id; } foreach($myarray $wpec_categories1){ $wpec_term_name = $wpec_categories1['name']; $wpec_term_slug = $wpec_categories1['slug']; $wpec_term_id = $wpec_categories1['term_id']; echo '<li> <a href="'.get_page_link(19)....
Read more

python - Installing PyDev in eclipse is failed -

unable read repository @ http://pydev.sf.net/updates/content.xml. sun.security.validator.validatorexception: pkix path building failed: sun.security.provider.certpath.suncertpathbuilderexception: unable find valid certification path requested target i installing pydev in eclipse using python, doesn't install successfully. gives above error. happened? how solve error? i had error when trying install on laptop behind corporate firewall. couldn't tell setup of firewall, not sure of root cause. i got passed error installing pydev eclipse when out behind firewall. another way got around have eclipse on non-firewalled machine, install pydev eclipse, , copy whole eclipse directory non-firewalled machine firewalled machine. there better way, , way fix properly, didn't have time work out firewall doing. this on windows 7 machine (yeah know) not work *nix versions installed through package manager yum or apt.
Read more