Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-5668

Comment times should be set by server and display timezone

      Comment times don't make sense – looks like they're being set by the browser (in different time zones). See attached screenshot, where a preceeding comment has a timestamp later than the following one.

          Form Name

            [CONFSERVER-5668] Comment times should be set by server and display timezone

            This is the result of CONF-860 – the default date/time format for Confluence was a 12-hour clock without an AM/PM marker. This was fixed for Conflunce 1.0-rc6, but we never made the corresponding configuration change on confluence.atlassian.com when we upgraded.

            I've fixed the date format on confluence.atlassian.com to use a 24 hour clock.

            Charles Miller (Inactive) added a comment - This is the result of CONF-860 – the default date/time format for Confluence was a 12-hour clock without an AM/PM marker. This was fixed for Conflunce 1.0-rc6, but we never made the corresponding configuration change on confluence.atlassian.com when we upgraded. I've fixed the date format on confluence.atlassian.com to use a 24 hour clock.

            jens added a comment -

            I can confirm that this is an AM/PM issue.

            jens added a comment - I can confirm that this is an AM/PM issue.

            Yup:

            http://confluence.atlassian.com/display/JIRAEXT/WorklogListener+-+Modify+the+creation+time+for+a+worklog

            Matt

            Matt Kenigson
            Systems Integrator
            Franklin American Mortgage
            mkenigson@franklinamerican.com
            v. 615-778-2720
            f. 615-778-2763

            Matt Kenigson added a comment - Yup: http://confluence.atlassian.com/display/JIRAEXT/WorklogListener+-+Modify+the+creation+time+for+a+worklog Matt – Matt Kenigson Systems Integrator Franklin American Mortgage mkenigson@franklinamerican.com v. 615-778-2720 f. 615-778-2763

            Matt Ryall added a comment -

            Oh, thanks for letting us know.

            Do you remember which page this was on?

            Matt Ryall added a comment - Oh, thanks for letting us know. Do you remember which page this was on?

            Matt,

            I really don't know. I was commenting on behavior I saw at
            confluence.atlassian.com. We don't use confluence here, so it's
            possible that what I saw (and attached a screenshot of) may have been an
            AM/PM thing. Either way, it should be addressed.

            Thanks,

            Matt Kenigson

            Matt Kenigson
            Systems Integrator
            Franklin American Mortgage
            mkenigson@franklinamerican.com
            v. 615-778-2720
            f. 615-778-2763

            Matt Kenigson added a comment - Matt, I really don't know. I was commenting on behavior I saw at confluence.atlassian.com. We don't use confluence here, so it's possible that what I saw (and attached a screenshot of) may have been an AM/PM thing. Either way, it should be addressed. Thanks, Matt Kenigson – Matt Kenigson Systems Integrator Franklin American Mortgage mkenigson@franklinamerican.com v. 615-778-2720 f. 615-778-2763

            The comment timestamp is set on the server side, and the comments should always be ordered by creationdate on a page.

            Are you able to have a look at the timestamps on these comments in your database? Replace XXX with the ID of the comment, which you can get from the end of the 'Permalink' URL (just the number bit).

            SELECT creationdate, lastmoddate FROM content WHERE contentid = XXX

            The creation date is what appears on the page, and should be the sort order as well. If this isn't the case here, we have ourselves an interesting bug.

            Matt Ryall added a comment - The comment timestamp is set on the server side, and the comments should always be ordered by creationdate on a page. Are you able to have a look at the timestamps on these comments in your database? Replace XXX with the ID of the comment, which you can get from the end of the 'Permalink' URL (just the number bit). SELECT creationdate, lastmoddate FROM content WHERE contentid = XXX The creation date is what appears on the page, and should be the sort order as well. If this isn't the case here, we have ourselves an interesting bug.

            ...or is this an AM/PM issue? Looks like it may be related to CONF-1026 in any case

            Matt Kenigson added a comment - ...or is this an AM/PM issue? Looks like it may be related to CONF-1026 in any case

              Unassigned Unassigned
              912609b306bf Matt Kenigson
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: