diff options
author | mkanat%kerio.com <> | 2005-02-25 07:37:47 +0000 |
---|---|---|
committer | mkanat%kerio.com <> | 2005-02-25 07:37:47 +0000 |
commit | 63dde60072374b2f7ef2f756d4ab9dff66669793 (patch) | |
tree | 294b30fddd43508bc9fa4d8c3c540ac4bbcd3c8c /CGI.pl | |
parent | 32882b6e3513fa69185ea5b3d115e70b69ea5362 (diff) | |
download | bugs-63dde60072374b2f7ef2f756d4ab9dff66669793.tar bugs-63dde60072374b2f7ef2f756d4ab9dff66669793.tar.gz bugs-63dde60072374b2f7ef2f756d4ab9dff66669793.tar.bz2 bugs-63dde60072374b2f7ef2f756d4ab9dff66669793.tar.xz bugs-63dde60072374b2f7ef2f756d4ab9dff66669793.zip |
Bug 280500: Replace "DATE_FORMAT()" with Bugzilla::DB function call
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=myk
Diffstat (limited to 'CGI.pl')
-rw-r--r-- | CGI.pl | 7 |
1 files changed, 4 insertions, 3 deletions
@@ -317,6 +317,7 @@ sub LogActivityEntry { sub GetBugActivity { my ($id, $starttime) = (@_); my $datepart = ""; + my $dbh = Bugzilla->dbh; die "Invalid id: $id" unless $id=~/^\s*\d+\s*$/; @@ -333,9 +334,9 @@ sub GetBugActivity { my $query = " SELECT COALESCE(fielddefs.description, bugs_activity.fieldid), fielddefs.name, - bugs_activity.attach_id, - DATE_FORMAT(bugs_activity.bug_when,'%Y.%m.%d %H:%i:%s'), - bugs_activity.removed, bugs_activity.added, + bugs_activity.attach_id, " . + $dbh->sql_date_format('bugs_activity.bug_when', '%Y.%m.%d %H:%i:%s') . + ", bugs_activity.removed, bugs_activity.added, profiles.login_name FROM bugs_activity $suppjoins LEFT JOIN fielddefs ON bugs_activity.fieldid = fielddefs.fieldid, |