[Python-Dev] datetime nanosecond support

Chris Lambacher chris at kateandchris.net
Wed Jul 25 05:12:05 CEST 2012

On Tue, Jul 24, 2012 at 9:46 PM, Guido van Rossum <guido at python.org> wrote:

> I didn't read the entire bug, but it mentioned something about storing
> datetimes in databases. Do databases support nanosecond precision?

MS SQL Server 2008 R2 has the datetime2 data type which supports 100
nanosecond (.1 microsecond) precision:

PostgreSQL does 1 microsecond:

If I am reading this correctly the Oracle TIMESTAMP type allows up to 9
digits of fractional seconds (1 nanosecond):


Christopher Lambacher
chris at kateandchris.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-dev/attachments/20120724/7c2287a3/attachment.html>

More information about the Python-Dev mailing list