backend/server/rhnServer/server_packages.py | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 2dca8e92f7066b4391b4dd2b5985cbbd1cddbaea
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Mar 16 17:36:48 2012 +0100
804036 - need to use timestamp datatype to preserve the precision.
diff --git a/backend/server/rhnServer/server_packages.py b/backend/server/rhnServer/server_packages.py
index 31545d1..394c8e7 100644
--- a/backend/server/rhnServer/server_packages.py
+++ b/backend/server/rhnServer/server_packages.py
@@ -205,7 +205,7 @@ class Packages:
insert into rhnServerPackage
(server_id, name_id, evr_id, package_arch_id, installtime)
values (:sysid, LOOKUP_PACKAGE_NAME(:n), LOOKUP_EVR(:e, :v, :r),
- LOOKUP_PACKAGE_ARCH(:a), TO_DATE(:instime, 'YYYY-MM-DD HH24:MI:SS')
+ LOOKUP_PACKAGE_ARCH(:a), TO_TIMESTAMP(:instime, 'YYYY-MM-DD HH24:MI:SS')
)
""")
# some fields are not allowed to contain empty string (varchar)