67 lines
1.6 KiB
Perl
67 lines
1.6 KiB
Perl
package Koha::DateTime::Format::SQL;
|
|
|
|
# This file is part of Koha.
|
|
#
|
|
# Koha is free software; you can redistribute it and/or modify it
|
|
# under the terms of the GNU General Public License as published by
|
|
# the Free Software Foundation; either version 3 of the License, or
|
|
# (at your option) any later version.
|
|
#
|
|
# Koha is distributed in the hope that it will be useful, but
|
|
# WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
# GNU General Public License for more details.
|
|
#
|
|
# You should have received a copy of the GNU General Public License
|
|
# along with Koha; if not, see <https://www.gnu.org/licenses>.
|
|
|
|
=head1 NAME
|
|
|
|
Koha::DateTime::Format::SQL - Parse SQL dates
|
|
|
|
=head1 SYNOPSIS
|
|
|
|
$datetime = Koha::DateTime::Format::SQL->parse_datetime($sql_datetime_string);
|
|
|
|
=cut
|
|
|
|
use Modern::Perl;
|
|
|
|
use DateTime::Format::MySQL;
|
|
|
|
use Koha::Config;
|
|
|
|
our $timezone;
|
|
|
|
=head1 API
|
|
|
|
=head2 Class methods
|
|
|
|
=head3 parse_datetime
|
|
|
|
Parse an SQL datetime string and returns a corresponding L<DateTime> object
|
|
|
|
$datetime = Koha::DateTime::Format::SQL->parse_datetime($rfc3339_datetime_string);
|
|
|
|
DateTime's time zone is automatically set to the configured timezone (or
|
|
'local' if none is configured), unless the year is 9999 in which case the
|
|
timezone is 'floating'.
|
|
|
|
=cut
|
|
|
|
sub parse_datetime {
|
|
my ( $class, $date ) = @_;
|
|
|
|
my $dt = DateTime::Format::MySQL->parse_datetime($date);
|
|
|
|
# No TZ for dates 'infinite' => see bug 13242
|
|
if ( $dt->year < 9999 ) {
|
|
$timezone //= Koha::Config->get_instance->timezone;
|
|
$dt->set_time_zone($timezone);
|
|
}
|
|
|
|
return $dt;
|
|
}
|
|
|
|
1;
|