use POSIX;

$dbh->do(
        'INSERT INTO announcements ( msg, start_timestamp, end_timestamp ) VALUES (?,?,?)',
                undef,
                'Hello World',
                strftime("%Y-%m-%d %H:%M:%S",localtime(time)),
                strftime("%Y-%m-%d %H:%M:%S",localtime(time+2000))
        );