Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Time::Piece::MySQL(3) User Contributed Perl DocumentationTime::Piece::MySQL(3)

NAME
       Time::Piece::MySQL - Adds MySQL-specific	methods	to Time::Piece

SYNOPSIS
	 use Time::Piece::MySQL;

	 my $time = localtime;

	 print $time->mysql_datetime;
	 print $time->mysql_date;
	 print $time->mysql_time;

	 my $time = Time::Piece->from_mysql_datetime( $mysql_datetime );
	 my $time = Time::Piece->from_mysql_date( $mysql_date );
	 my $time = Time::Piece->from_mysql_timestamp( $mysql_timestamp	);

DESCRIPTION
       Using this module instead of, or	in addition to,	"Time::Piece" adds a
       few MySQL-specific date-time methods to "Time::Piece" objects.

OBJECT METHODS
   mysql_date /	mysql_time / mysql_datetime / mysql_timestamp
       Returns the date	and/or time in a format	suitable for use by MySQL.

CONSTRUCTORS
   from_mysql_date / from_mysql_datetime / from_mysql_timestamp
       Given a date, datetime, or timestamp value as returned from MySQL,
       these constructors return a new Time::Piece object.  If the value is
       NULL, they will retrun undef.

   CAVEAT
       "Time::Piece" itself only works with times in the Unix epoch, this
       module has the same limitation.	However, MySQL itself handles date and
       datetime	columns	from '1000-01-01' to '9999-12-31'.  Feeding in times
       outside of the Unix epoch to any	of the constructors has	unpredictable
       results.

       Also, MySQL doesn't validate dates (because your	application should);
       it only checks that dates are in	the right format.  So, your database
       might include dates like	2004-00-00 or 2001-02-31.  Passing invalid
       dates to	any of the constructors	is a bad idea: on my system the	former
       type (with zeros) returns undef (previous version used to die) while
       the latter returns a date in the	following month.

AUTHOR
       Original	author:	Dave Rolsky <autarch@urth.org>

       Current maintainer: Marty Pauley	<marty+perl@kasei.com>

COPYRIGHT
       (c) 2002	Dave Rolsky

       (c) 2004	Marty Pauley

       This program is free software; you can redistribute it and/or modify it
       under the same terms as Perl itself.

SEE ALSO
       Time::Piece

perl v5.24.1			  2008-06-07		 Time::Piece::MySQL(3)

NAME | SYNOPSIS | DESCRIPTION | OBJECT METHODS | CONSTRUCTORS | AUTHOR | COPYRIGHT | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Time::Piece::MySQL&sektion=3&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help