SQL::Statement::Functions::Date - More date/time functions River stage one • 1 direct dependent • 1 total dependent

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 Per...

PERLANCAR/SQL-Statement-Functions-Date-0.04 - 25 Jan 2017 06:33:32 GMT

SQL::Statement::Function::ByName::DAY - DAY() SQL function River stage one • 1 direct dependent • 1 total dependent

Implements DAY() SQL function. It is synonym for DAYOFMONTH()....

PERLANCAR/SQL-Statement-Functions-Date-0.04 - 25 Jan 2017 06:33:32 GMT

SQL::Statement::Function::ByName::YEAR - YEAR() SQL function River stage one • 1 direct dependent • 1 total dependent

Implements YEAR() SQL function. Syntax: YEAR(date) Return integer (e.g. 2015), or undef if argument is not detected as date....

PERLANCAR/SQL-Statement-Functions-Date-0.04 - 25 Jan 2017 06:33:32 GMT

SQL::Statement::Function::ByName::MONTH - MONTH() SQL function River stage one • 1 direct dependent • 1 total dependent

Implements MONTH() SQL function. Syntax: MONTH(date) Returns 1-12, or undef if argument is not detected as date....

PERLANCAR/SQL-Statement-Functions-Date-0.04 - 25 Jan 2017 06:33:32 GMT

SQL::Statement::Function::ByName::WEEKDAY - WEEKDAY() SQL function River stage one • 1 direct dependent • 1 total dependent

Implements WEEKDAY() SQL function. Syntax: WEEKDAY(date) Returns 0-6 (0=Monday, 6=Sunday), or undef if argument is not detected as date....

PERLANCAR/SQL-Statement-Functions-Date-0.04 - 25 Jan 2017 06:33:32 GMT

SQL::Statement::Function::ByName::DAYOFYEAR - DAYOFYEAR() SQL function River stage one • 1 direct dependent • 1 total dependent

Implements DAYOFYEAR() SQL function. Syntax: DAYOFYEAR(date) Returns 1-366, or undef if argument is not detected as date....

PERLANCAR/SQL-Statement-Functions-Date-0.04 - 25 Jan 2017 06:33:32 GMT

SQL::Statement::Function::ByName::WEEKOFYEAR - WEEKOFYEAR() SQL function River stage one • 1 direct dependent • 1 total dependent

Implements WEEKOFYEAR() SQL function. Syntax: WEEKOFYEAR(date) Returns 1-53, or undef if argument is not detected as date....

PERLANCAR/SQL-Statement-Functions-Date-0.04 - 25 Jan 2017 06:33:32 GMT

SQL::Statement::Function::ByName::DAYOFMONTH - DAYOFMONTH() SQL function River stage one • 1 direct dependent • 1 total dependent

Implements DAYOFMONTH() SQL function. Syntax: DAYOFMONTH(date) Returns 1-31, or undef if argument is not detected as date....

PERLANCAR/SQL-Statement-Functions-Date-0.04 - 25 Jan 2017 06:33:32 GMT

SQL::Statement::Function::ByName::ISO_YEARWEEK - ISO_YEARWEEK() SQL function River stage one • 1 direct dependent • 1 total dependent

Given a date in YYYY-mm-dd format, will return the ISO 8601 YYYY-Www format. Example: ISO_YEARWEEK('2016-01-01') -- 2015W53 ISO_YEARWEEK('2016-01-04') -- 2016W01 This can be an alternative to WEEKOFYEAR(), where it can give e.g. 53 even though the da...

PERLANCAR/SQL-Statement-Functions-Date-0.04 - 25 Jan 2017 06:33:32 GMT

9 results (0.02 seconds)