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::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