Search results for "module:SQL::Statement::Function"
SQL::Statement::Function - abstract base class for all function executing terms
SQL::Statement::Function is an abstract base class providing the interface for all function executing terms....
REHSACK/SQL-Statement-1.414 - 21 Oct 2020 14:46:55 UTC
SQL::Statement::Function::ByName::IF - SQL function to return a value or the other depending on condition
Caveat: the notion of true and false follows Perl's notion. Caveat: due to the current limitation of SQL::Parser, this function is not as useful as it should be, e.g. SQL::Parser cannot parse this correctly: SELECT IF(col > 10, a, b) FROM table...
PERLANCAR/SQL-Statement-Functions-Logic-0.001 - 25 Jan 2017 06:33:35 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::ARGMINNUM - SQL function to return the (numerically) minimum parameter
Uses List::Util's "min"....
PERLANCAR/SQL-Statement-Functions-ArgMinMax-0.002 - 25 Jan 2017 06:33:30 UTC
SQL::Statement::Function::ByName::ARGMINSTR - SQL function to return the (string-wise) minimum parameter
Uses List::Util's "minstr"....
PERLANCAR/SQL-Statement-Functions-ArgMinMax-0.002 - 25 Jan 2017 06:33:30 UTC
SQL::Statement::Function::ByName::ARGMAXNUM - SQL function to return the (numerically) maximum parameter
Uses List::Util's "max"....
PERLANCAR/SQL-Statement-Functions-ArgMinMax-0.002 - 25 Jan 2017 06:33:30 UTC
SQL::Statement::Function::ByName::ARGMAXSTR - SQL function to return the (string-wise) maximum parameter
Uses List::Util's "maxstr"....
PERLANCAR/SQL-Statement-Functions-ArgMinMax-0.002 - 25 Jan 2017 06:33:30 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
SQL::Statement::Util
This package contains three utility classes to handle deliverable columns....
REHSACK/SQL-Statement-1.414 - 21 Oct 2020 14:46:55 UTC