Do you know where your variables are? | |
PerlMonks |
Re: DBD-InterBase: different date/time formatsby paulbort (Hermit) |
on Jun 22, 2004 at 17:18 UTC ( [id://368792]=note: print w/replies, xml ) | Need Help?? |
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 Section
Seekers of Perl Wisdom
|
|