Search results for "distribution:SQL-Statement-Functions-Date sql::statement"
SQL::Statement::Functions::Date - More date/time functions
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.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::DAY - Synonym for DAYOFMONTH() SQL function
Implements DAY() SQL function. It is synonym for DAYOFMONTH()....
PERLANCAR/SQL-Statement-Functions-Date-0.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::DATE - Return the date part (e.g. 2022-12-13) of a date/datetime expression
Implements DATE() SQL function to return the date part, like in MySQL. Syntax: DATE(date) Return "2022-12-13", or undef if argument is not detected as date....
PERLANCAR/SQL-Statement-Functions-Date-0.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::TIME - Return the time part (e.g. 13:56:57) of a date/datetime expression
Implements TIME() SQL. Syntax: TIME(date) Return time part, e.g. "13:56:57" or undef if expression is not detected as a datetime....
PERLANCAR/SQL-Statement-Functions-Date-0.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::HOUR - Return the hour part (00-23) of a date/datetime expression
Implements HOUR() SQL. Syntax: HOUR(date) Return 00-23, or undef if argument is not detected as datetime....
PERLANCAR/SQL-Statement-Functions-Date-0.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::YEAR - Return the year part from a date/datetime expression
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.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::MONTH - Return the month part of a date/datetime expression
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.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::SECOND - Return the second part (00-60) of a date/datetime expression
Implements SECOND() SQL. Syntax: SECOND(date) Return 01-60, or undef if argument is not detected as datetime....
PERLANCAR/SQL-Statement-Functions-Date-0.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::MINUTE - Return the minute part (00-59) of a date/datetime expression
Implements MINUTE() SQL. Syntax: MINUTE(date) Return 01-59, or undef if argument is not detected as datetime....
PERLANCAR/SQL-Statement-Functions-Date-0.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::WEEKDAY - WEEKDAY() SQL function
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.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::DAYOFYEAR - Return day of year of a date/datetime expression
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.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::WEEKOFYEAR - Return week of the year from a date/datetime expression
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.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::DAYOFMONTH - Return day of month of a date/datetime expression
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.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::ISO_YEARWEEK - Return ISO 8601 YYYY-"W"ww (e.g. 2022-W51) of a date/datetime expression
Given a date in YYYY-mm-dd format, will return the ISO 8601 YYYY-"W"ww 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 ...
PERLANCAR/SQL-Statement-Functions-Date-0.050 - 24 Dec 2022 00:05:27 UTC