[sqlalchemy] Re: date format

2007-02-01 Thread Guy Hulbert
On Thu, 2007-01-02 at 07:53 +0100, jose wrote: Thank you Guy to answer my question. I know I can use the strftime property of datetime to format my dates as: qry.data_inizio.strftime('%d/%m/%Y') but what I'm looking for, is a way to setting date style in SA or psycopg2 whithout need

[sqlalchemy] Re: date format

2007-01-31 Thread Guy Hulbert
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. jo -- Guy Hulbert [EMAIL PROTECTED] (preferred) work: (416) 391-2051 (no voicemail) cell: (416) 738-6257 (voicemail

[sqlalchemy] Re: date format

2007-01-31 Thread Guy Hulbert
On Wed, 2007-31-01 at 12:17 -0500, Guy Hulbert wrote: 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

[sqlalchemy] SQL Views ?

2007-01-30 Thread Guy Hulbert
Will there eventually be a 'View' in the SQLAlchemy API, like 'Table'. I have been trying to find an example but 'view' tends to hit MVC references in google searches. -- --gh --~--~-~--~~~---~--~~ You received this message because you are subscribed to the

[sqlalchemy] Re: SQL Views ?

2007-01-30 Thread Guy Hulbert
= View( ... ) v.create() but I can do it via SQL for now. is generally not available, someone would have to make the effort to implement that for all the database modules. Ahh ... I see. Ok. tqvm On Jan 30, 2007, at 5:50 PM, Guy Hulbert wrote: Will there eventually