View Issue Details

IDProjectCategoryView StatusLast Update
0003160mantisbtbugtrackerpublic2007-05-08 03:42
Reporterstagomantis Assigned Toachumakov  
PrioritynormalSeveritytextReproducibilityalways
Status closedResolutionfixed 
Fixed in Version1.1.0a2 
Summary0003160: Please use ISO dates in this installation
Description

Since Mantis is a product used by people from all over the world, this implementation should take its international audience into account.

I have problems deciphering your dates (they are ambiguous). Please change the date format for this installation to use the ISO format (yyyy-mm-dd): this is not only completely unambiguous, but also an international standard, and a format used as standard in many countries.

Additional Information

I also think the ISO format for dates should be the default configuration, again considering the international user community.

(Of course I'm using ISO dates in my own installation - so coming here it was a rather unpleasant surprise not to be able to decipher dates...)

TagsNo tags attached.
Attached Files
3160-not-iso-dates.png (10,102 bytes)   
3160-not-iso-dates.png (10,102 bytes)   

Relationships

related to 0001139 closedachumakov [all lang] date localisation 
has duplicate 0006636 closedryandesign Please use ISO dates in this installation 
has duplicate 0007137 closedryandesign International-style dates 
has duplicate 0007280 closedryandesign date format 

Activities

proffe

proffe

2005-02-07 15:02

reporter   ~0009237

At the very least, change the default date format to m/d/y. That way it is possible to tell 05/02/03 (May 2, 2003) from 05-02-03 (February 5, 2005). Still, I can't understand why any programmers, even US ones, would use middle-endian byte order...

gtomlin

gtomlin

2005-02-07 17:12

reporter   ~0009241

There's nothing about slashes vs. dashes that defines the meaning of each of the numbers. The thing that makes ISO 8601 easy for everyone to understand is that the 4-digit number is obviously the year. Of course, there are many other advantages to ISO 8601 as well:
http://www.iso.org/iso/en/prods-services/popstds/datesandtime.html
http://www.cl.cam.ac.uk/~mgk25/iso-time.html

stagomantis

stagomantis

2005-02-07 17:31

reporter   ~0009243

Proffe,
"At the very least, change the default date format to m/d/y. That way it is possible to tell 05/02/03 (May 2, 2003) from 05-02-03 (February 5, 2005)."

I'm flummoxed... 05/02/03 could mean:
3 February 2005
5 February 2003
2 May 2003
From the format there is no clue which of the elements is which (no, a separator does not tell you that). How would you tell the difference?
It's totally ambiguous - and thus totally unusable as a default format!

I'm also somewhat stunned that after my submission on '04-29-03' (now is that 29 March 2004 or 29 April 2003?) there apparently has been no action on this issue. It's acknowledged, and some people are monitoring it. Yes, some people are adding notes, too. And that's it.

Are the Mantis developers not interested in an international audience?

thraxisp

thraxisp

2005-02-07 17:38

reporter   ~0009244

You can reconfigure these yourself through config_inc.php.

# --- date format settings --------
# date format strings (default is 'US' formatting)
# go to http://www.php.net/manual/en/function.date.php
# for detailed instructions on date formatting
$g_short_date_format    = 'm-d-y';
$g_normal_date_format   = 'm-d-y H:i';
$g_complete_date_format = 'm-d-Y H:i T';

They are currently US formatting. I'd like ISO as well as defaults.

proffe

proffe

2005-02-07 17:46

reporter   ~0009245

Of course, I'm Swedish myself, and I agree on the superiority of ISO 8601. It's just that I've never seen a MDY date with dashes (which increases the confusion) anywhere except in Mantis.

proffe

proffe

2005-02-07 18:08

reporter   ~0009247

To thraxisp: I think we all are aware of that. I maintain that the default setting should be changed, since the current default is completely ambiguous. Since this issue is about the configuration of just this site I was thinking of opening a separate, but related, issue.

To stagomantis: It can't mean 3 February 2005 - if you decide that you always use dashes with YMD. I was under an impression that some separators are (slightly) more common with certain formats than with others.

In principle, we all agree.

stagomantis

stagomantis

2005-02-07 18:16

reporter   ~0009248

thraxisp,
Yes, a date format can be configured - in the application. So it can be configured for THIS INSTALLATION as well.

Please read the subject which describes what I'm asking for:
"Please change the date format for this installation to use the ISO format (yyyy-mm-dd)".

THIS INSTALLATION.

Which is still using undecipherable dates - I can't even tell when I actually submitted this request in THIS INSTALLATION.

prescience

prescience

2005-02-07 20:35

reporter   ~0009250

Fixed!

ryandesign

ryandesign

2006-01-25 13:20

reporter   ~0012020

If it was fixed, then it somehow got un-fixed. This installation is still (or once again) using an ambiguous date format.

grangeway

grangeway

2006-04-17 15:55

reporter   ~0012559

Hello,

This comes under 'date localisation' - resolving as duplicate.

We need to add date/time formatting and store in a consistent format, then display in another.

ryandesign

ryandesign

2006-06-05 08:37

reporter   ~0012939

I don't call this a duplicate of 0001139. That's more concerned with the grand scheme of users being able to show dates and times in their own formats, on any Mantis installation, while this bug is very specifically limited to changing the configuration of this Mantis installation to use the international date format, which can happen before any solution exists for 0001139.

rickb

rickb

2006-06-05 09:06

reporter   ~0012940

I'm guessing (because of date ambiguity) but it looks like nearly a year since this issue was raised. Is it really that hard for someone to edit the config.inc.php for /this installation/?

We need
$g_short_date_format = 'Y-M-d'

Thanks in advance.

ryandesign

ryandesign

2006-06-18 12:43

reporter   ~0012977

Actually I believe we need this:

$g_short_date_format   = 'Y-m-d';
$g_normal_date_format = 'Y-m-d H:i';
$g_complete_date_format = 'Y-m-d H:i T';

davide73italy

davide73italy

2006-06-21 05:52

reporter   ~0013008

I agree with you; YYYY-MM-DD (and 24 hour time-format) should be used both in bugs.mantisbt.org website than in the config_defaults_inc.php file!

ryandesign

ryandesign

2006-12-09 16:47

reporter   ~0013790

This issue is not resolved. This bug says it's fixed in 1.1.0a2, but this installation is using 1.1.0a2 and is still not showing ISO dates.

achumakov

achumakov

2006-12-09 17:47

reporter   ~0013791

I can't reproduce -- looks OK for me.
Could you please add a screenshot or a description where is the date wrong?

ryandesign

ryandesign

2006-12-11 03:13

reporter   ~0013796

Well, everywhere a date appears. Date Submitted. Last Update. Notes. History. I see dates like "06-12-09"; ISO format would be "2006-12-09". See attachment "3160-not-iso-dates.png".

achumakov

achumakov

2006-12-11 08:01

reporter   ~0013801

OK, will change that.

andre_steffens

andre_steffens

2007-03-20 15:55

reporter   ~0014219

Also I think it would be usefull to change the date format from unix_timestamp to a better format. At the moment the range is only from 1970-01-01 to 2038-01-19.

Dates should be save and handle as "19700101093025" means "1970-01-01 09:30:25" = "Y-m-d H:i:s" with this change we wouldn't become problems in 2038!

ryandesign

ryandesign

2007-03-20 16:00

reporter   ~0014220

andre_steffens: please file a new feature request for that, if none already exists. The comment does not belong in this bug report.

vboctor

vboctor

2007-03-24 20:31

manager   ~0014240

I've updated this installation's configuration. The latest Mantis code also uses the ISO format.