<div class="gmail_quote">On Tue, Jul 24, 2012 at 9:46 PM, Guido van Rossum <span dir="ltr"><<a href="mailto:guido@python.org" target="_blank">guido@python.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div id=":10a">I didn't read the entire bug, but it mentioned something about storing<br>
datetimes in databases. Do databases support nanosecond precision?</div></blockquote></div><br>MS SQL Server 2008 R2 has the datetime2 data type which supports 100 nanosecond (.1 microsecond) precision:<div><a href="http://msdn.microsoft.com/en-us/library/bb677335(v=sql.105)">http://msdn.microsoft.com/en-us/library/bb677335(v=sql.105)</a> <br clear="all">
<div><br></div><div>PostgreSQL does 1 microsecond:</div><div><a href="http://www.postgresql.org/docs/8.0/static/datatype-datetime.html">http://www.postgresql.org/docs/8.0/static/datatype-datetime.html</a>
</div><div><br></div><div>If I am reading this correctly the Oracle TIMESTAMP type allows up to 9 digits of fractional seconds (1 nanosecond):</div><div><a href="http://docs.oracle.com/cd/B19306_01/server.102/b14195/sqlqr06.htm#r9c1-t3">http://docs.oracle.com/cd/B19306_01/server.102/b14195/sqlqr06.htm#r9c1-t3</a>
</div><div><br></div><div>-Chris</div><div><br></div>-- <br>Christopher Lambacher<br><a href="mailto:chris@kateandchris.net">chris@kateandchris.net</a><br>
</div>