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?
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
"Ein Volk, ein Reich, ein Fuhrer" - Adolf Hitler
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: DBI & date/timestamp problem
by Yendor (Pilgrim) on Jan 26, 2006 at 16:38 UTC | |
Re: DBI & date/timestamp problem
by VSarkiss (Monsignor) on Jan 26, 2006 at 16:10 UTC | |
by BigGuy (Friar) on Jan 26, 2006 at 16:20 UTC | |
Re: DBI & date/timestamp problem
by ptum (Priest) on Jan 26, 2006 at 17:37 UTC | |
Re: DBI & date/timestamp problem
by BigGuy (Friar) on Jan 26, 2006 at 17:39 UTC |
Back to
Seekers of Perl Wisdom