summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorterry%mozilla.org <>2000-03-08 06:55:58 +0100
committerterry%mozilla.org <>2000-03-08 06:55:58 +0100
commit39e31cfee09851c2ee47f59024c8da1713bd96d6 (patch)
tree9f1741e8d862e453a3ca05c5c16d9c0f71238e9d
parenta1f341024427582cf8a7988442614d1b0f4bf61f (diff)
downloadbugzilla-39e31cfee09851c2ee47f59024c8da1713bd96d6.tar.gz
bugzilla-39e31cfee09851c2ee47f59024c8da1713bd96d6.tar.xz
Patch by Peter Schweiger <schweiger.peter@litef.de> -- date formatting
string wasn't working with modern MySQL engines.
-rw-r--r--bug_form.pl2
-rwxr-xr-xbuglist.cgi4
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");