[sqlalchemy] Re: date format - Guy Hulbert - com.googlegroups.sqlalchemy

6 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: date format

Subject:	[sqlalchemy] Re: date format
From:	Guy Hulbert (gwhu...@eol.ca)
Date:	01/31/2007 09:16:42 AM
List:	com.googlegroups.sqlalchemy

On Wed, 2007-31-01 at 17:50 -0400, Jose Soares wrote:

Hi all,

I would like to display my dates with format '%d/%m/%Y' instead of ISO format.

qry = session.query(Nazione).select(Nazione.c.codice=='201') qry[0].data_inizio print qry[0].data_inizio 2006-01-14

Is there a way to set it in SA without using a customer function ?

Something like:

'/'.join(s.split('-').reverse())

where 's' is the string you want to reformat, would do it.