<html><head><meta name="color-scheme" content="light dark"></head><body><pre style="word-wrap: break-word; white-space: pre-wrap;">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-&gt;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

</pre></body></html>