MySql to Python Date

Question

I try to convert MySQl datetime to same in Python.On debug there is

ValueError: time data '2001-06-04T11:30:35' doesn't match format %Y-%m-%dT%H:%M:%S . In MySQL there is no 'T' in data.I tried format with 'T' and without.

I saw this article How to convert the following string to python date? .

This is code:

query = QSqlQuery ()
query.exec_("SELECT birthday FROM vista.user ")    
def countAge(birthday):
    birthday = datetime.strptime(str(birthday), "%Y-%m-%dT%H:%M:%S.%f")
    today = date.today()
    age = today.year - birthday.year
    if today.month < birthday.month:
        age -= 1
    elif today.month == birthday.month and today.day < birthday.day:
        age -= 1
    if age >= 0 :   
        return age
ages = []
index = 0
while (query.next()):
    print(query.value(index).toString())
    ages.append(countAge(query.value(index).toString()))
    index = index + 1

What is a problem?

So what is the output of: print(query.value(index).toString())? — ekhumoro
– ekhumoro, Commented Nov 22, 2016 at 20:59

ekhumoro · Accepted Answer · 2016-11-22 21:36:16Z

2

If an example date-string is 2001-06-04T11:30:35, then you need:

    birthday = datetime.strptime(str(birthday), "%Y-%m-%dT%H:%M:%S")

answered Nov 22, 2016 at 21:36

ekhumoro

122k23 gold badges272 silver badges400 bronze badges

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

Collectives™ on Stack Overflow

MySql to Python Date

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related