Search results for "module:SQL::Statement::Functions"

SQL::Statement::Functions - built-in & user-defined SQL functions River stage two • 21 direct dependents • 77 total dependents

This module contains the built-in functions for SQL::Parser and SQL::Statement. All of the functions are also available in any DBDs that subclass those modules (e.g. DBD::CSV, DBD::DBM, DBD::File, DBD::AnyData, DBD::Excel, etc.). This documentation c...

REHSACK/SQL-Statement-1.414 - 21 Oct 2020 14:46:55 UTC

SQL::Statement::Functions::Date - More date/time functions River stage zero No dependents

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 UTC

SQL::Statement::Functions::Logic - Logic functions River stage zero No dependents

This distribution contains several SQL functions to be used with SQL::Statement: IF() To use a function from Perl script: require SQL::Statement::Function::ByName::IF; $dbh->do(qq{CREATE FUNCTION IF NAME "SQL::Statement::Function::ByName::MAXNUM::SQL...

PERLANCAR/SQL-Statement-Functions-Logic-0.001 - 25 Jan 2017 06:33:35 UTC

SQL::Statement::Functions::ArgMinMax - ARGMIN*/ARGMAX* functions River stage zero No dependents

This distribution contains several SQL functions to be used with SQL::Statement: ARGMAXNUM() ARGMAXSTR() ARGMINNUM() ARGMINSTR() These functions are not aggregate functions. They are added due to the lack of CASE statement as well as IF function in S...

PERLANCAR/SQL-Statement-Functions-ArgMinMax-0.002 - 25 Jan 2017 06:33:30 UTC

SQL::Statement::Function::ByName::IF - SQL function to return a value or the other depending on condition River stage zero No dependents

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 - DAY() SQL function River stage zero No dependents

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

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

SQL::Statement::Function::ByName::YEAR - YEAR() SQL function River stage zero No dependents

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 UTC

SQL::Statement::Function::ByName::MONTH - MONTH() SQL function River stage zero No dependents

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 UTC

SQL::Statement::Function::ByName::WEEKDAY - WEEKDAY() SQL function River stage zero No dependents

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 UTC

SQL::Statement::Function::ByName::ARGMINNUM - SQL function to return the (numerically) minimum parameter River stage zero No dependents

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 River stage zero No dependents

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 River stage zero No dependents

Uses List::Util's "max"....

PERLANCAR/SQL-Statement-Functions-ArgMinMax-0.002 - 25 Jan 2017 06:33:30 UTC

SQL::Statement::Function::ByName::DAYOFYEAR - DAYOFYEAR() SQL function River stage zero No dependents

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 UTC

SQL::Statement::Function::ByName::ARGMAXSTR - SQL function to return the (string-wise) maximum parameter River stage zero No dependents

Uses List::Util's "maxstr"....

PERLANCAR/SQL-Statement-Functions-ArgMinMax-0.002 - 25 Jan 2017 06:33:30 UTC

SQL::Statement::Function::ByName::WEEKOFYEAR - WEEKOFYEAR() SQL function River stage zero No dependents

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 UTC

SQL::Statement::Function::ByName::DAYOFMONTH - DAYOFMONTH() SQL function River stage zero No dependents

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 UTC

SQL::Statement::Function::ByName::ISO_YEARWEEK - ISO_YEARWEEK() SQL function River stage zero No dependents

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 UTC

Fey::SQL - Documentation on SQL generation with Fey and SQL object factory River stage one • 6 direct dependents • 9 total dependents

This module mostly exists to provide documentation and a factory interface for making SQL statement objects. For convenience, loading this module loads all of the "Fey::SQL::*" classes, such as Fey::SQL::Select, Fey::SQL::Delete, etc....

DROLSKY/Fey-0.43 - 16 Jun 2015 03:55:50 UTC

Quiq::Sql - Klasse zur Generierung von SQL River stage zero No dependents

Zweck der Klasse Die Klasse unterstützt die Entwicklung von portablen Datenbankanwendungen, d.h. Anwendungen, die unter mehreren DBMSen lauffähig sein sollen. Dies wird erreicht, indem die Klasse Methoden zur Verfügung stellt, die zum DBMS den passen...

FSEITZ/Quiq-1.205 - 23 Oct 2022 17:42:39 UTC

PApp::SQL - absolutely easy yet fast and powerful sql access. River stage one • 1 direct dependent • 1 total dependent

This module provides you with easy-to-use functions to execute sql commands (using DBI). Despite being easy to use, they are also quite efficient and allow you to write faster programs in fewer lines of code. It should work with anything from perl-5....

MLEHMANN/PApp-SQL-2.002 - 04 Mar 2019 06:26:17 UTC
56 results (0.042 seconds)