I haven't worked with InterBase specifically, but my guess is that DBD::Interbase is now paying attention to the locale that it is in, and trying to provide the data in a format appropriate to that locale.

You can test this on the Windows box by telling it you're in Europe (Control Panel/Settings/Regional and Language Options on XP), and running the same program again. I expect you'll get a date with the month and day transposed, or with the year first.

If that happens, then you just need to determine how DBD::Interbase determines the locale, and how you can set the machines to the same locale, or override the system setting.

Another option would be to change the query to do the formatting for you. For example, the PostgreSQL to_char() function would allow you to specify the output format in the query, so that both clients would get a string in the exact same format. Simply converting the date to a string as part of the query might be enough to get it into a consistent format, too.

--
Spring: Forces, Coiled Again!

In reply to Re: DBD-InterBase: different date/time formats by paulbort
in thread DBD-InterBase: different date/time formats by pet

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.