From 0fcc20760ab4c49ec7e3b93f9025a9b0b8d2046b Mon Sep 17 00:00:00 2001
From: "jake%bugzilla.org" <>
Date: Thu, 28 Nov 2002 00:00:20 +0000
Subject: Bug 67077 - We now include the timezone (as configured in
 editparams.cgi) on every time we display. r=justdave a=justdave

---
 Attachment.pm | 10 ++--------
 1 file changed, 2 insertions(+), 8 deletions(-)

(limited to 'Attachment.pm')

diff --git a/Attachment.pm b/Attachment.pm
index 53690170e..27d7fa2ca 100644
--- a/Attachment.pm
+++ b/Attachment.pm
@@ -69,8 +69,8 @@ sub query
   # Retrieve a list of attachments for this bug and write them into an array
   # of hashes in which each hash represents a single attachment.
   &::SendSQL("
-              SELECT attach_id, creation_ts, mimetype, description, ispatch, 
-               isobsolete, isprivate, submitter_id
+              SELECT attach_id, DATE_FORMAT(creation_ts, '%Y.%m.%d %H:%i'),
+              mimetype, description, ispatch, isobsolete, isprivate, submitter_id
               FROM attachments WHERE bug_id = $bugid ORDER BY attach_id
             ");
   my @attachments = ();
@@ -81,12 +81,6 @@ sub query
      $a{'ispatch'}, $a{'isobsolete'}, $a{'isprivate'}, $submitter_id) 
         = &::FetchSQLData();
 
-    # Format the attachment's creation/modification date into a standard
-    # format (YYYY-MM-DD HH:MM)
-    if ($a{'date'} =~ /^(\d\d\d\d)(\d\d)(\d\d)(\d\d)(\d\d)(\d\d)$/) {
-        $a{'date'} = "$1-$2-$3 $4:$5";
-    }
-
     # Retrieve a list of flags for this attachment.
     $a{'flags'} = Bugzilla::Flag::match({ 'attach_id' => $a{'attachid'} });
     
-- 
cgit v1.2.3-24-g4f1b