php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #51924 Missing MySQL datetime format in list of valid formats
Submitted: 2010-05-26 17:19 UTC Modified: 2010-10-20 06:20 UTC
From: george at providentdata dot com Assigned: kalle (profile)
Status: Closed Package: Documentation problem
PHP Version: Irrelevant OS: n/a
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: george at providentdata dot com
New email:
PHP Version: OS:

 

 [2010-05-26 17:19 UTC] george at providentdata dot com 
Description:
------------
The page:

http://www.php.net/manual/en/datetime.formats.compound.php

lists datetime formats that are accepted by eg. strtotime() and such.

These functions accept the MySQL datetime format:
YY "-" MM "-" DD " " HH ":" II ":" SS
but the format isn't listed.

Closest formats listed are EXIF:
YY ":" MM ":" DD " " HH ":" II ":" SS

and WDDX:
YY "-" mm "-" dd "T" hh ":" ii ":" ss

neither of whose format strings match MySQL.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2010-10-20 02:21 UTC] kalle@php.net 
Automatic comment from SVN on behalf of kalle
Revision: http://svn.php.net/viewvc/?view=revision&revision=304519
Log: Fixed bug #51924 (Missing MySQL datetime format in list of valid formats)
 [2010-10-20 02:22 UTC] kalle@php.net
-Status: Open +Status: Closed -Assigned To: +Assigned To: kalle
 [2010-10-20 02:22 UTC] kalle@php.net 
This bug has been fixed in the documentation's XML sources. Since the
online and downloadable versions of the documentation need some time
to get updated, we would like to ask you to be a bit patient.

Thank you for the report, and for helping us make our documentation better.
 [2020-02-07 06:09 UTC] phpdocbot@php.net 
Automatic comment on behalf of kalle
Revision: http://git.php.net/?p=doc/en.git;a=commit;h=e1f7f5aecfbff94e0c39962e44f4581f46d6062b
Log: Fixed bug #51924 (Missing MySQL datetime format in list of valid formats)
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Jul 02 04:01:38 2025 UTC