Am Freitag, 18. Januar 2008 22:43 schrieb Michael Bayer:
> On Jan 18, 2008, at 10:59 AM, Hermann Himmelbauer wrote:
> > Hi,
> > I have a table that looks appr. like this (I deleted some columns):
> >
> > table_acc = Table(
> >    'konto', metadata,
> >    Column('kontoid', Integer, primary_key=True, key='accid'),
> >
> > What can I do about this? It seems, that "now()" is not recognized,
> > but how is
> > this possible?
> >
> > I am using SA 0.4.1, SA0.4.2p3 + Python-2.4.4 and sqllite.
>
> with sqlite use func.current_timestamp() instead of now().

Yes, this did the trick - thank's a lot!
One more question: I user sqlite only for testing my database application, for 
the real thing I'll use MaxDB and/or postgresql; Will 
func.current_timestamp() work for these databases, or should I set up some 
proxy function that returns either now() or current_timestamp() regarding to 
the database?

Best Regards,
Hermann

-- 
[EMAIL PROTECTED]
GPG key ID: 299893C7 (on keyservers)
FP: 0124 2584 8809 EF2A DBF9  4902 64B4 D16B 2998 93C7

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to