use Date::Calc;

$dbh->func("NOW",
           0,
           sub { sprintf('%d-%02d-%02d %02d:%02d:%02d',
                         Date::Calc::Today_and_Now) },
           "create_aggregate");