[SQL-CVS] r2774 - in SQLObject/branches/0.8: docs sqlobject

[<sub...@co...>]

Author: phd
Date: 2007-07-20 03:10:05 -0600 (Fri, 20 Jul 2007)
New Revision: 2774

Modified:
   SQLObject/branches/0.8/docs/News.txt
   SQLObject/branches/0.8/sqlobject/converters.py
Log:
Fixed a bug N 1757262 in converting date/time for years < 1000 (time.strptime()
requires exactly 4 digits for %Y, hence a year < 1000 must be 0-padded).


Modified: SQLObject/branches/0.8/docs/News.txt
===================================================================
--- SQLObject/branches/0.8/docs/News.txt	2007-07-20 09:09:28 UTC (rev 2773)
+++ SQLObject/branches/0.8/docs/News.txt	2007-07-20 09:10:05 UTC (rev 2774)
@@ -195,6 +195,9 @@
 
 * Fixed a bug in col.createSQL().
 
+* Fixed a bug in converting date/time for years < 1000 (time.strptime()
+  requires exactly 4 digits for %Y, hence a year < 1000 must be 0-padded).
+
 SQLObject 0.7.7
 ===============
 

Modified: SQLObject/branches/0.8/sqlobject/converters.py
===================================================================
--- SQLObject/branches/0.8/sqlobject/converters.py	2007-07-20 09:09:28 UTC (rev 2773)
+++ SQLObject/branches/0.8/sqlobject/converters.py	2007-07-20 09:10:05 UTC (rev 2774)
@@ -204,14 +204,14 @@
 
 if datetime:
     def DateTimeConverter(value, db):
-        return "'%4d-%02d-%02d %02d:%02d:%02d'" % (
+        return "'%04d-%02d-%02d %02d:%02d:%02d'" % (
             value.year, value.month, value.day,
             value.hour, value.minute, value.second)
 
     registerConverter(datetime.datetime, DateTimeConverter)
 
     def DateConverter(value, db):
-        return "'%4d-%02d-%02d'" % (value.year, value.month, value.day)
+        return "'%04d-%02d-%02d'" % (value.year, value.month, value.day)
 
     registerConverter(datetime.date, DateConverter)