By blarg on

I have users that have each created a profile. In this profile they note their date of birth. These are all showing everywhere as:

1970-05-10 H:i

Obviously we don't care about the hours and seconds. In the configuration I see a short date format that includes hours and seconds, but none are availiable that don't have this. Which db table is this format stored in so I can axe the H:i or is there an easier way to accomplish this?

⋅ Categories: Drupal 4.6.x

Comments

blarg’s picture

blarg commented

I found the date formats in the variable table, but the short format is:

YYYY-MM-DD - H:i

Note the dash in the middle. So I looked at the profile fields and the date is stored like:

a:3:{s:4:"year";s:4:"1983";s:5:"month";s:1:"4";s:3:"day";s:2:"27";}

I don't know what the letter:number is for, but this is obviously getting fed through a date-prettier-upper that isn't the main one, because I set the date formats to year-month-day with nothing else and we still showed H:i. I did turn the cache off to make sure that wasn't the issue.

yourhiro’s picture

yourhiro commented

What version of Drupal are you running?

In the function profile_view_field of profile.module, there is a section that formats the date.

In 4.6.5, it looks like this:

      case 'date':
        list($format) = explode(' - ', variable_get('date_format_short', 'm/d/Y - H:i'), 2);
        // Note: we avoid PHP's date() because it does not handle dates before
        // 1970 on Windows. This would make the date field useless for e.g.
        // birthdays.
        $replace = array('d' => sprintf('%02d', $value['day']),
                         'j' => $value['day'],
                         'm' => sprintf('%02d', $value['month']),
                         'M' => _profile_map_month($value['month']),
                         'Y' => $value['year']);
        return strtr($format, $replace);

and in 4.7:

        $format = substr(variable_get('date_format_short', 'm/d/Y - H:i'), 0, 5);
        // Note: Avoid PHP's date() because it does not handle dates before
        // 1970 on Windows. This would make the date field useless for e.g.
        // birthdays.
        $replace = array('d' => sprintf('%02d', $value['day']),
                         'j' => $value['day'],
                         'm' => sprintf('%02d', $value['month']),
                         'M' => map_month($value['month']),
                         'Y' => $value['year'],
                         'H:i' => null,
                         'g:ia' => null);
        return strtr($format, $replace);

It appears it replaces all the tags for the m/d/y/h/i values with its own variables. The 4.6.5 version is lacking the 'H:i' => null line so the H:i tag isn't being replaced(removed, since replaces with null)...and simply gets sent through.

Try adding that line in:

        $replace = array('d' => sprintf('%02d', $value['day']),
                        'j' => $value['day'],
                        'm' => sprintf('%02d', $value['month']),
                        'M' => _profile_map_month($value['month']),
                        'Y' => $value['year'],
                        'H:i' => null);
blarg’s picture

blarg commented

Drupal 4.6.6, and that section of code in my profile.module looks like:

        $replace = array('d' => sprintf('%02d', $value['day']),
                         'j' => $value['day'],
                         'm' => sprintf('%02d', $value['month']),
                         'M' => _profile_map_month($value['month']),
                         'Y' => $value['year']);

Changing it as you suggest has resolved the issue.