NAME
SQL::Statement::Function::ByName::ISO_YEARWEEK - ISO_YEARWEEK() SQL function
VERSION
This document describes version 0.04 of SQL::Statement::Function::ByName::ISO_YEARWEEK (from Perl distribution SQL-Statement-Functions-Date), released on 2017-01-25.
DESCRIPTION
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 date is in the first week of January.
WEEKOFYEAR('2016-01-01') -- 53
WEEKOFYEAR('2016-01-04') -- 1
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.
BUGS
Please report any bugs or feature requests on the bugtracker website https://rt.cpan.org/Public/Dist/Display.html?Name=SQL-Statement-Functions-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.
AUTHOR
perlancar <perlancar@cpan.org>
COPYRIGHT AND LICENSE
This software is copyright (c) 2017 by 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.