Re: Loading calendar database

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
-- 
Common sense is what tells you that the world is flat.

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]