We don't bite newbies here... much | |
PerlMonks |
DBI & date/timestamp problemby BigGuy (Friar) |
on Jan 26, 2006 at 16:02 UTC ( [id://525752]=perlquestion: print w/replies, xml ) | 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
Back to
Seekers of Perl Wisdom
|
|