Re^4: Timestamp problem

[Anonymous Monk]

here's what you likely ended up with :

use POSIX;

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