[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Omaha.pm] SQL . sprintf

Before

    my @T = Date::Calc::Today;
    $filter .= " AND extend(arrival_date,year to day) >= '" .
       sprintf("%04d-%02d-%02d",$T[0..2]) . "'";

After

    $filter .= " AND extend(arrival_date,year to day) >= " .
       sprintf("'%04d-%02d-%02d'", Date::Calc::Today);

j