Is isn't clear from your "question" where the problem might be, but there are a few things you can try...

Make sure you quote the year field (eg, '02') as MySQL will helpfully strip the leading zeros off bare numbers (eg, 02).

If you're INSERTing this data using DBI and placeholders, it's possible DBI is misquoting your input.

Using bind_params may help to coerce it otherwise, or you could explicitly pad your input instead so that the absence of quotes on numbers becomes a non-issue (eg, INSERT ... LPAD(?, 2, 0)).

Padding works equally well if you prefer to tackle this on the output side of things, and can be done in your SQL as above (eg, SELECT ... LPAD(...)) or by massaging the results in Perl afterwards (eg, sprintf '%02s', $year_col, but note the use of 's' instead of the more common 'd').

    --k.


In reply to Re: working with year in mysql by Kanji
in thread working with year in mysql by mkahn

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.