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

FreeBSD Manual Pages

  
 
  

home | help
DateTime::Format::MySQUser Contributed Perl DocumentDateTime::Format::MySQL(3)

NAME
       DateTime::Format::MySQL - Parse and format MySQL	dates and times

SYNOPSIS
	 use DateTime::Format::MySQL;

	 my $dt	= DateTime::Format::MySQL->parse_datetime( '2003-01-16 23:12:01' );

	 # 2003-01-16 23:12:01
	 DateTime::Format::MySQL->format_datetime($dt);

DESCRIPTION
       This module understands the formats used	by MySQL for its DATE,
       DATETIME, TIME, and TIMESTAMP data types.  It can be used to parse
       these formats in	order to create	DateTime objects, and it can take a
       DateTime	object and produce a string representing it in the MySQL
       format.

METHODS
       This class offers the following methods.	 All of	the parsing methods
       set the returned	DateTime object's time zone to the floating time zone,
       because MySQL does not provide time zone	information.

       o   parse_datetime($string)

       o   parse_date($string)

       o   parse_timestamp($string)

	   Given a value of the	appropriate type, this method will return a
	   new "DateTime" object.  The time zone for this object will always
	   be the floating time	zone, because by MySQL stores the local
	   datetime, not UTC.

	   If given an improperly formatted string, this method	may die.

       o   format_date($datetime)

       o   format_time($datetime)

       o   format_datetime($datetime)

	   Given a "DateTime" object, this methods returns an appropriately
	   formatted string.

SUPPORT
       Support for this	module is provided via the datetime@perl.org email
       list.  See http://lists.perl.org/ for more details.

AUTHOR
       Dave Rolsky <autarch@urth.org>

COPYRIGHT
       Copyright (c) 2003-2014 David Rolsky.  All rights reserved.  This
       program is free software; you can redistribute it and/or	modify it
       under the same terms as Perl itself.

       The full	text of	the license can	be found in the	LICENSE	file included
       with this module.

SEE ALSO
       datetime@perl.org mailing list

       http://datetime.perl.org/

perl v5.32.0			  2020-08-27	    DateTime::Format::MySQL(3)

NAME | SYNOPSIS | DESCRIPTION | METHODS | SUPPORT | AUTHOR | COPYRIGHT | SEE ALSO

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

home | help