On Thu, May 6, 2010 at 2:42 PM, Chris Rebert <c...@rebertia.com> wrote:
> On Thu, May 6, 2010 at 1:47 AM, Kurian Thayil <kurianmtha...@gmail.com>
> wrote:
> <snip>
> > the expected output is 05:35:05.
> >
> > Now, here is code snippet,
> >
> > cursor1=getconnect1.cursor()
> > getrows=cursor1.execute("""SELECT
> > TIME(DATE_ADD(info_last_calltime, INTERVAL %s MINUTE)) FROM rem_call_info
> > WHERE info_ctrlid=%s""", (retryinterval,controlid1,))
> > rawstatus20result=cursor1.fetchone()
> > print "Raw result is",rawstatus20result
> > status20result=rawstatus20result[0]
> > print "The query result for Status
> > 20:",status20result,";Time now is",timeformat
> >
> > The output is:
> >
> > Raw result is (datetime.timedelta(0, 20105),)
> > The query result for Status 20: 5:35:05 ;Time now is 05:22:00
> > Match not found.
> > New call to be made
> > Getting next value if any...
> >
> > If you look closer, the time fetched by python module was 5:35:05 instead
> of
> > 05:35:05. How can I get this time format? Thanks in advance.
>
> You're getting back a time delta (i.e. quantity/duration of time, e.g.
> "3 hours") rather than an actual time (i.e. temporal coordinates for a
> particular instant of time, e.g. "5:15PM and 2 seconds"), and
> timedelta defines its stringification differently, hence your issue. I
> would guess that getting back a timedelta instead of a time is some
> quirk of MySQLdb; haven't used it though, so I'm just guessing.
>
> Anyway, you can work around this by converting the timedelta object to
> a time object yourself:
> #Untested Code!
> from datetime import time
> minutes, seconds = divmod(status20result.seconds, 60)
> hours, minutes = divmod(minutes, 60)
> time_result = time(hours, minutes, seconds, status20result.microseconds)
> print "The query result for Status 20:",time_result,";Time now
> is",timeformat
>
> Cheers,
> Chris
> --
> http://blog.rebertia.com
>
That worked Chris. Thank you.
Regards,
Kurian Thayil.
--
http://mail.python.org/mailman/listinfo/python-list
