Hi Marc, The problem is probably not with psycopg, but with Python's time structures such as mxDateTime. The strftime() function in Linux and Windows is one of many date/time functions that do not support anything less than seconds. You can circumvent this by using PostgreSQL's type conversion functions to pass a formatted string back to psycopg:
=> SELECT to_char(now(), 'HH:MM:SS.MS'); You can then parse the string yourself. Eric Radman | http://eradman.com On 20:30 Mon 26 Jul , Marc Saric wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi all, > > is anyone here who has some experience with psycopg > (PostgreSQL-DB2.0-adapter)? > > This is certainly unrelated to WebWare, but the psycopg-list has been > silent so far. > > I have a problem with TIMESTAMPS, they get mangled (milliseconds cut > off, millisecond-separator beeing a "," instead of ".") by psycopg and I > don't know why. > > Currently I use PyGreSQL because of this, but it lacks certain functions > (support for BLOB-insertion, string-escaping) and is in general badly > documented (the DB2.0-API compliant adapter, not the old one). > > Thanks in advance. > > - -- > Bye, > Marc Saric http://www.marcsaric.de > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.4 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFBBU3IvKxJUF29wRIRAtDzAJ0YswcJ0IadE81ROlZJyeqeBco1egCdH5RZ > It3Z5mbkF7K7DE8xm9Byo0Q= > =Yv6f > -----END PGP SIGNATURE----- ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss
