Programming Forums > Script Programming > Python

poopman · Feb 12th, 2007, 3:06 PM

Hey all,

I've wrtting something that gathers the date from a mySQL database but I need to be able to grab the year, or month, or day, or everything if needed. When I get the date from my database I get this:

(datetime.date(2007, 2, 9),)

How would I format it so I can have the dates end up like this?:

2009-02-09

Any help is much appreciated! :banana:

Arevos · Feb 12th, 2007, 3:12 PM

 python Syntax (Toggle Plain Text) 
dateObject.strftime("%Y-%m-%d")
dateObject.strftime("%Y-%m-%d")

poopman · Feb 12th, 2007, 3:21 PM

Cool, thanks.

Another question as I am fairly new to python. How do I apply the .strftime to that tuple that I posted?

Arevos · Feb 12th, 2007, 5:04 PM

If you want to access an element of a tuple, you can use indices, in the same way you would an array or list:

 python Syntax (Toggle Plain Text) 
result = (datetime.date(2007, 2, 9),)
date = result[0]
print date.strftime("%Y-%m-%d")
result = (datetime.date(2007, 2, 9),)
date = result[0]
print date.strftime("%Y-%m-%d")

Or simply:

 python Syntax (Toggle Plain Text) 
print result[0].strftime("%Y-%m-%d")
print result[0].strftime("%Y-%m-%d")

You can also assign a tuple to an set of variables to get its contents:

 python Syntax (Toggle Plain Text) 
coords = (4, 6)
x, y = coords
coords = (4, 6)
x, y = coords

And for a tuple with a single value:

 python Syntax (Toggle Plain Text) 
result = (datetime.date(2007, 2, 9),)
date, = result
result = (datetime.date(2007, 2, 9),)
date, = result

This notation when applied to only one value is a little obscure, however.

poopman · Feb 12th, 2007, 5:22 PM

Quote:

Originally Posted by Arevos

If you want to access an element of a tuple, you can use indices, in the same way you would an array or list:

 python Syntax (Toggle Plain Text) 
result = (datetime.date(2007, 2, 9),)
date = result[0]
print date.strftime("%Y-%m-%d")
result = (datetime.date(2007, 2, 9),)
date = result[0]
print date.strftime("%Y-%m-%d")

Or simply:

 python Syntax (Toggle Plain Text) 
print result[0].strftime("%Y-%m-%d")
print result[0].strftime("%Y-%m-%d")

You can also assign a tuple to an set of variables to get its contents:

 python Syntax (Toggle Plain Text) 
coords = (4, 6)
x, y = coords
coords = (4, 6)
x, y = coords

And for a tuple with a single value:

 python Syntax (Toggle Plain Text) 
result = (datetime.date(2007, 2, 9),)
date, = result
result = (datetime.date(2007, 2, 9),)
date, = result

This notation when applied to only one value is a little obscure, however.

Thanks for this. I tried out all these methods and kept coming up with this error:

AttributeError: 'tuple' object has no attribute 'strftime'

I can't figure out why this isn't working as it seems pretty straightfoward.

Arevos · Feb 12th, 2007, 5:38 PM

What that means is that the object you're trying to reference is not a date object, but a tuple. Might I see your code?

poopman · Feb 12th, 2007, 5:45 PM

I had to omit the SQL statement for work purposes, but here's all the code after that:

(Toggle Plain Text)

cursor.execute(sql_first_look)
result = cursor.fetchall()
date = result[0]

print date.strftime("%Y-%m-%d")
connection.commit()
cursor.close()
connection.close()

Arevos · Feb 12th, 2007, 5:57 PM

The "fetchall" function returns a list of tuples that represents the rows in your resultset. So result[0] returns the first item of the list; a tuple. You'd have to then index that again to get the first item of the tuple: result[0][0]

However, if you only expect your SQL to return one result, it's better to use "fetchone" instead.

 python Syntax (Toggle Plain Text) 
cursor.execute(sql_first_look)
result = cursor.fetchone()
date = result[0]
 
print date.strftime("%Y-%m-%d")
cursor.execute(sql_first_look)
result = cursor.fetchone()
date = result[0]

print date.strftime("%Y-%m-%d")

Also, I'm not sure you need connection.commit() unless your SQL statement is part of a transaction that alters the database. Nor do you need to close your cursor separately to your database; closing the database closes the cursor too.

So it's likely you just need:

 python Syntax (Toggle Plain Text) 
connection.close()
connection.close()

poopman · Feb 12th, 2007, 6:01 PM

That worked! Thanks a lot!

:banana: :banana:

Feb 12th, 2007, 3:06 PM	#1
poopman Newbie Join Date: Feb 2007 Posts: 13 Rep Power: 0	Formatting date from MySQLdb Hey all, I've wrtting something that gathers the date from a mySQL database but I need to be able to grab the year, or month, or day, or everything if needed. When I get the date from my database I get this: (datetime.date(2007, 2, 9),) How would I format it so I can have the dates end up like this?: 2009-02-09 Any help is much appreciated! :banana:

Feb 12th, 2007, 3:12 PM	#2
Arevos Programming Guru Join Date: Aug 2005 Location: England Posts: 1,499 Rep Power: 5	python Syntax (Toggle Plain Text) dateObject.strftime("%Y-%m-%d") dateObject.strftime("%Y-%m-%d")

Feb 12th, 2007, 5:04 PM	#4
Arevos Programming Guru Join Date: Aug 2005 Location: England Posts: 1,499 Rep Power: 5	If you want to access an element of a tuple, you can use indices, in the same way you would an array or list: python Syntax (Toggle Plain Text) result = (datetime.date(2007, 2, 9),) date = result[0] print date.strftime("%Y-%m-%d") result = (datetime.date(2007, 2, 9),) date = result[0] print date.strftime("%Y-%m-%d") Or simply: python Syntax (Toggle Plain Text) print result[0].strftime("%Y-%m-%d") print result[0].strftime("%Y-%m-%d") You can also assign a tuple to an set of variables to get its contents: python Syntax (Toggle Plain Text) coords = (4, 6) x, y = coords coords = (4, 6) x, y = coords And for a tuple with a single value: python Syntax (Toggle Plain Text) result = (datetime.date(2007, 2, 9),) date, = result result = (datetime.date(2007, 2, 9),) date, = result This notation when applied to only one value is a little obscure, however.

Feb 12th, 2007, 5:45 PM	#7
poopman Newbie Join Date: Feb 2007 Posts: 13 Rep Power: 0	I had to omit the SQL statement for work purposes, but here's all the code after that: (Toggle Plain Text) cursor.execute(sql_first_look) result = cursor.fetchall() date = result[0] print date.strftime("%Y-%m-%d") connection.commit() cursor.close() connection.close() cursor.execute(sql_first_look) result = cursor.fetchall() date = result[0] print date.strftime("%Y-%m-%d") connection.commit() cursor.close() connection.close()

Feb 12th, 2007, 5:57 PM	#8
Arevos Programming Guru Join Date: Aug 2005 Location: England Posts: 1,499 Rep Power: 5	The "fetchall" function returns a list of tuples that represents the rows in your resultset. So result[0] returns the first item of the list; a tuple. You'd have to then index that again to get the first item of the tuple: result[0][0] However, if you only expect your SQL to return one result, it's better to use "fetchone" instead. python Syntax (Toggle Plain Text) cursor.execute(sql_first_look) result = cursor.fetchone() date = result[0] print date.strftime("%Y-%m-%d") cursor.execute(sql_first_look) result = cursor.fetchone() date = result[0] print date.strftime("%Y-%m-%d") Also, I'm not sure you need connection.commit() unless your SQL statement is part of a transaction that alters the database. Nor do you need to close your cursor separately to your database; closing the database closes the cursor too. So it's likely you just need: python Syntax (Toggle Plain Text) connection.close() connection.close()

Feb 12th, 2007, 3:21 PM	#3
poopman Newbie Join Date: Feb 2007 Posts: 13 Rep Power: 0	Cool, thanks. Another question as I am fairly new to python. How do I apply the .strftime to that tuple that I posted?

Feb 12th, 2007, 5:38 PM	#6
Arevos Programming Guru Join Date: Aug 2005 Location: England Posts: 1,499 Rep Power: 5	What that means is that the object you're trying to reference is not a date object, but a tuple. Might I see your code?

Feb 12th, 2007, 6:01 PM	#9
poopman Newbie Join Date: Feb 2007 Posts: 13 Rep Power: 0	That worked! Thanks a lot! :banana: :banana:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Routine	tbohon	Perl	2	Jan 15th, 2007 11:14 AM
converting string to float	beginnerCCC	C	22	Oct 2nd, 2006 11:59 PM
Php Postgresql Class	Pizentios	Show Off Your Open Source Projects	15	Jun 28th, 2005 9:55 AM
How custom formatting for date picker is achieved?	sham	Visual Basic	1	Apr 9th, 2005 5:56 PM
Enquiry About Visual Basic Project	kbkhoo5053	Visual Basic	13	Feb 15th, 2005 2:20 AM

Programming Forums > Script Programming > Python

Formatting date from MySQLdb