Jan Eden wrote on 20.12.2004:
Hi,
I plan to move my Data::Dumper based occupancy table to a real
database. While the database itself is quite, I am not sure how to
load it with the appropriate dates (including February 29, 2008
etc).
Is there a Perl module or a certain technique for loading fields of
the date type with the appropriate information?
I already thought about a loop like
for (1..1000) {
$dbh->do(INSERT INTO ... VALUES ADDDATE('2004-01-01', INTERVAL $_ DAYS);
}
But there must be something better.
Thanks,
Jan