| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | James Thompson <jamest(at)ajrs(dot)com> |
| Cc: | PgSQL General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Python Interface |
| Date: | 2005-02-10 21:37:02 |
| Message-ID: | 20050210213702.GA72513@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Feb 10, 2005 at 01:29:42PM -0600, James Thompson wrote:
> Though if IIRC it does round timestamps which can burn a person at times :)
> I don't have a test case to verify if my memory is correct about this though.
Actually, I think it's just that mxDateTime defaults to displaying
times as HH:MM:SS.ss, but the extra precision does appear to be there:
In psql:
SELECT tm FROM foo;
tm
-----------------
14:32:41.219443
In Python:
curs.execute('SELECT tm FROM foo')
row = curs.dictfetchone()
print row['tm']
14:32:41.21
print row['tm'].second
41.219443
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-02-10 21:52:45 | Re: Functions with more than 32 parameters |
| Previous Message | Christoph Pingel | 2005-02-10 21:35:22 | Re: no self-joins in views? - works now! |