time::piece::mysql(3pm) [debian man page]

Time::Piece::MySQL(3pm) 				User Contributed Perl Documentation				   Time::Piece::MySQL(3pm)

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.12.4							    2008-06-07						   Time::Piece::MySQL(3pm)

Check Out this Related Man Page

Time::Seconds(3pm)					 Perl Programmers Reference Guide					Time::Seconds(3pm)

NAME

       Time::Seconds - a simple API to convert seconds to other date values

SYNOPSIS

	   use Time::Piece;
	   use Time::Seconds;

	   my $t = localtime;
	   $t += ONE_DAY;

	   my $t2 = localtime;
	   my $s = $t - $t2;

	   print "Difference is: ", $s->days, "
";

DESCRIPTION

       This module is part of the Time::Piece distribution. It allows the user to find out the number of minutes, hours, days, weeks or years in a
       given number of seconds. It is returned by Time::Piece when you delta two Time::Piece objects.

       Time::Seconds also exports the following constants:

	   ONE_DAY
	   ONE_WEEK
	   ONE_HOUR
	   ONE_MINUTE
	   ONE_MONTH
	   ONE_YEAR
	   ONE_FINANCIAL_MONTH
	   LEAP_YEAR
	   NON_LEAP_YEAR

       Since perl does not (yet?) support constant objects, these constants are in seconds only, so you cannot, for example, do this: "print
       ONE_WEEK->minutes;"

METHODS

       The following methods are available:

	   my $val = Time::Seconds->new(SECONDS)
	   $val->seconds;
	   $val->minutes;
	   $val->hours;
	   $val->days;
	   $val->weeks;
	       $val->months;
	       $val->financial_months; # 30 days
	   $val->years;
	   $val->pretty; # gives English representation of the delta

       The usual arithmetic (+,-,+=,-=) is also available on the objects.

       The methods make the assumption that there are 24 hours in a day, 7 days in a week, 365.24225 days in a year and 12 months in a year.
       (from The Calendar FAQ at http://www.tondering.dk/claus/calendar.html)

AUTHOR

       Matt Sergeant, matt@sergeant.org

       Tobias Brox, tobiasb@tobiasb.funcom.com

       BalXzs SzabX (dLux), dlux@kapu.hu

LICENSE

       Please see Time::Piece for the license.

Bugs
       Currently the methods aren't as efficient as they could be, for reasons of clarity. This is probably a bad idea.

POD ERRORS

       Hey! The above document had some coding errors, which are explained below:

       Around line 245:
	   Non-ASCII character seen before =encoding in 'BalXzs'. Assuming UTF-8

perl v5.18.2							    2014-01-06							Time::Seconds(3pm)

Linux and UNIX Man Pages

time::piece::mysql(3pm) [debian man page]

Check Out this Related Man Page