attribute error while trying to convert datetime to unix timestamp in python 2.7

Question

I'm querying a database to get a datetime and then trying to convert it to a unix timestamp. Here is some of my code:

#! /bin/python
import time, pytz
from datetime import datetime

eastern = pytz.timezone("US/Eastern")

def toUnix(dt):
    #converts a datetime to a unix timestamp
    return time.mktime(dt.timetuple())

def getFillStartTime(fillNo):
    #returns the start time of a fill as a unix time stamp
    dsacursor.execute('select startTime from fillInfo where fillNo = @fillNo',{'@fillNo':fillNo})
    sel = dsacursor.fetchall()
    dt = sel[0][0]
    dt = dt.replace(tzinfo = eastern)
    return toUnix(dt)

print getFillStartTime(20318)

When I run it I'm getting AttributeError: replace here is the traceback:

Traceback (most recent call last):
  File "test.py", line 27, in <module>
    print getFillStartTime(20318)
  File "importToLogView.py", line 25, in getFillStartTime
    dt = dt.replace(tzinfo = eastern)
AttributeError: replace

I have tested some things and dt of type DateTimeType when it is passed to the toUnix() function. Also, when I replace dt.timetuple() with datetime.now().timetuple() it prints the expected result. I have also tried not replacing the tzinfo and it gives AttributeError: timetuple instead. If it is a datetime, why is this error occurring?

What is the output if you put print type(dt) after dt = sel[0][0]? — user3657941
– user3657941, Commented Jul 31, 2017 at 15:45

Andrew Sledge · Accepted Answer · 2017-07-31 15:46:57Z

0

You're assuming that sel will be a datetime object, but it's not. It's not possible to derive that from the code snippet you have posted, and most likely is being returned as a string (database client depending). The general form for doing so is

dt = datetime.strptime(sel[0][0], '%b %d %Y %I:%M%p')

where %b %d %Y %I:%M%p is the format of the string.

EDIT: formatting

answered Jul 31, 2017 at 15:46

Andrew Sledge

10.4k2 gold badges31 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mike Delmonaco Over a year ago

if I print type(dt) after dt = sel[0][0] the output is <type 'DateTimeType'>

Andrew Sledge Over a year ago

Yes, I would assume so, because your database client is most likely casting that. Python datetime (and pytz) doesn't understand that, so you'll need to get it into <type 'datetime.datetime'> or something similar. Also, what database client are you using?

Mike Delmonaco Over a year ago

Thanks, that fixed it. I'm using Sybase.

Collectives™ on Stack Overflow

attribute error while trying to convert datetime to unix timestamp in python 2.7

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related