From 39e31cfee09851c2ee47f59024c8da1713bd96d6 Mon Sep 17 00:00:00 2001
From: "terry%mozilla.org" <>
Date: Wed, 8 Mar 2000 05:55:58 +0000
Subject: Patch by Peter Schweiger <schweiger.peter@litef.de> -- date
 formatting string wasn't working with modern MySQL engines.

---
 bug_form.pl | 2 +-
 buglist.cgi | 4 ++--
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/bug_form.pl b/bug_form.pl
index a556867f2..4ca7f43c5 100644
--- a/bug_form.pl
+++ b/bug_form.pl
@@ -146,7 +146,7 @@ select
 	target_milestone,
 	qa_contact,
 	status_whiteboard,
-        date_format(creation_ts,'Y-m-d H:i'),
+        date_format(creation_ts,'%Y-%m-%d %H:%i'),
         groupset,
 	delta_ts,
 	sum(votes.count)
diff --git a/buglist.cgi b/buglist.cgi
index 8cb09d427..a776bbc0b 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -769,9 +769,9 @@ sub DefCol {
     $::needquote{$name} = $q;
 }
 
-DefCol("opendate", "date_format(bugs.creation_ts,'Y-m-d')", "Opened",
+DefCol("opendate", "date_format(bugs.creation_ts,'%Y-%m-%d')", "Opened",
        "bugs.creation_ts");
-DefCol("changeddate", "date_format(bugs.delta_ts,'Y-m-d')", "Changed",
+DefCol("changeddate", "date_format(bugs.delta_ts,'%Y-%m-%d')", "Changed",
        "bugs.delta_ts");
 DefCol("severity", "substring(bugs.bug_severity, 1, 3)", "Sev",
        "bugs.bug_severity");
-- 
cgit v1.2.3-24-g4f1b