[Omaha.pm] SQL . sprintf

Jay Hannah jhannah at omnihotels.com
Tue Aug 16 10:41:19 PDT 2005


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




More information about the Omaha-pm mailing list