DESCRIPTION

   This distribution contains several SQL functions to be used with
   SQL::Statement:

    YEAR()
    MONTH()
    DAYOFYEAR()
    DAYOFMONTH()
    DAY()
    WEEKOFYEAR()
    WEEKDAY()

   They are based on MySQL's version. More functions wil be added as
   needed.

   To use a function from Perl script:

    require SQL::Statement::Function::ByName::YEAR;
    $dbh->do(qq{CREATE FUNCTION YEAR NAME "SQL::Statement::Function::ByName::YEAR::SQL_FUNCTION_YEAR"});

   To use a function from fsql:

    % fsql -F YEAR --add-csv path/to/sometable.csv "SELECT col1, YEAR(col2) FROM sometable ..."

SEE ALSO

   SQL::Statement

   App::fsql

You are viewing proxied material from ftp.icm.edu.pl. The copyright of proxied material belongs to its original authors. Any comments or complaints in relation to proxied material should be directed to the original authors of the content concerned. Please see the disclaimer for more details.