web/modules/rhn/RHN/DB/Scheduler.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
New commits: commit 266e5277fdb7de141d374b7dad906711a4f93720 Author: Ville Salmela Ville.Salmela@csc.fi Date: Tue May 10 09:48:37 2011 +0200
Fix remote command schedule date on postgresql
With this patch the scheduled command has an accurate date " 5/10/11 10:28:00 AM EEST " instead of "5/10/11 12:00:00 AM EEST"
diff --git a/web/modules/rhn/RHN/DB/Scheduler.pm b/web/modules/rhn/RHN/DB/Scheduler.pm index 2ee15e4..d494047 100644 --- a/web/modules/rhn/RHN/DB/Scheduler.pm +++ b/web/modules/rhn/RHN/DB/Scheduler.pm @@ -108,7 +108,7 @@ EOQ # TODO: fix sys_date => reasonable value later... my $query = <<EOQ; INSERT INTO rhnAction (id, org_id, action_type, scheduler, earliest_action, version, name, prerequisite) -VALUES (?, ?, ?, ?, TO_DATE(?, 'YYYY-MM-DD HH24:MI:SS'), 2, ?, ?) +VALUES (?, ?, ?, ?, TO_TIMESTAMP(?, 'YYYY-MM-DD HH24:MI:SS'), 2, ?, ?) EOQ
$sth = $dbh->prepare($query);