|XP is just a number|
DBI & date/timestamp problemby BigGuy (Friar)
|on Jan 26, 2006 at 16:02 UTC||Need Help??|
BigGuy has asked for the wisdom of the Perl Monks concerning the following question:
I have a small program that takes a flat file and dumps it to a postgres table via DBI. Previously it just inserted the dates as a text string, someone now wants the dates in a date or a timestamp field to improve sorting capabilities.
No big deal right? Somewhere along the line my date are being interpolated wrongly, or I could be feeding the data in wrong I'm not quite sure.
The date format in the flat file is yy-mm-dd
In my code I split it up, and rearrange it how postgres wants it (mm/dd/yyyy)
I've tried /'s and -'s as delimeters.
Example: raw date from file: 05-12-01
modified date as i insert it: 12/01/2005
date stored in table after insertion: 2001-05-12
Example 2: raw date from file: 06-01-25
modified date as i insert it: 01/25/2006
date stored in table after insertion: 2025-06-01
The behavior is exactly the same whether its a timestamp field or a date field.
This seems like such a trivial problem, but it has really thrown me for a loop. Any ideas what I am doing wrong?
BigGuy "One World, one Web, one Program" - Microsoft promotional ad
"Ein Volk, ein Reich, ein Fuhrer" - Adolf Hitler