The Perl Toolchain Summit 2025 Needs You: You can help 🙏 Learn more

PERLANCAR / SQL-Statement-Functions-Date-0.050 / README 

            

              
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81

              
NAME
    SQL::Statement::Functions::Date - More date/time functions
VERSION
    This document describes version 0.050 of SQL::Statement::Functions::Date
    (from Perl distribution SQL-Statement-Functions-Date), released on
    2022-12-12.
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::SQL_FUNCTION_YEAR"});
    To use a function from fsql:
     % fsql -F YEAR --add-csv path/to/sometable.csv "SELECT col1, YEAR(col2) FROM sometable ..."
HOMEPAGE
    Please visit the project's homepage at
    <https://metacpan.org/release/SQL-Statement-Functions-Date>.
SOURCE
    Source repository is at
    <https://github.com/perlancar/perl-SQL-Statement-Functions-Date>.
SEE ALSO
    SQL::Statement
    App::fsql
AUTHOR
    perlancar <perlancar@cpan.org>
CONTRIBUTOR
    Steven Haryanto <stevenharyanto@gmail.com>
CONTRIBUTING
    To contribute, you can send patches by email/via RT, or send pull
    requests on GitHub.
    Most of the time, you don't need to build the distribution yourself. You
    can simply modify the code, then test via:
     % prove -l
    If you want to build the distribution (e.g. to try to install it locally
    on your system), you can install Dist::Zilla,
    Dist::Zilla::PluginBundle::Author::PERLANCAR,
    Pod::Weaver::PluginBundle::Author::PERLANCAR, and sometimes one or two
    other Dist::Zilla- and/or Pod::Weaver plugins. Any additional steps
    required beyond that are considered a bug and can be reported to me.
COPYRIGHT AND LICENSE
    This software is copyright (c) 2022, 2017, 2016, 2015 by perlancar
    <perlancar@cpan.org>.
    This is free software; you can redistribute it and/or modify it under
    the same terms as the Perl 5 programming language system itself.
BUGS
    Please report any bugs or feature requests on the bugtracker website
    <https://rt.cpan.org/Public/Dist/Display.html?Name=SQL-Statement-Functio
    ns-Date>
    When submitting a bug or request, please include a test-file or a patch
    to an existing test-file that illustrates the bug or desired feature.