Mysql date_add 1 year <p>Can someone help me figure out why adding 1 year doesn't work for me?</p> <p>I have 6 other conditions (1 day, 1 week, 2 month, etc). The only one NOT working is the year.</p> <p>Anyone see why? In case it matters, this is Perl.</p> <pre><code>elsif ($data{length} == "6month") { $store = qq(INSERT INTO main (creator_name,email2,relationship,reason,email1,name1,creator_email,email3,name2,name3,creator_url,victim_url,length_of_stay,release_date) VALUES("$data{creatorname}","$data{email2}","$data{relationship}","$data{reason}","$data{email1}","$data{person1}","$data{creatoremail}","$data{email3}","$data{person2}","$data{person3}", "$creatorURL", "$victimURL","$data{length}", DATE_ADD(NOW(), INTERVAL 6 MONTH)) ); } elsif($data{length} == "1year") { $store = qq(INSERT INTO main (creator_name,email2,relationship,reason,email1,name1,creator_email,email3,name2,name3,creator_url,victim_url,length_of_stay,release_date) VALUES("$data{creatorname}","$data{email2}","$data{relationship}","$data{reason}","$data{email1}","$data{person1}","$data{creatoremail}","$data{email3}","$data{person2}","$data{person3}", "$creatorURL", "$victimURL","$data{length}", DATE_ADD(NOW(), INTERVAL 1 YEAR)) ); } my $sth = $dbh-&gt;prepare($store); $sth-&gt;execute() or die $dbh-&gt;errstr; </code></pre>