note 126977 added to book.datetime
| From: | theking2 at king dot ma | Date: | Fri, 08 Apr 2022 09:11:15 +0000 |
| Subject: | note 126977 added to book.datetime | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-218139@lists.php.net to get a copy of this message | ||
If working with SQL databases it is important to realize that where DB normally reserve 0000-00-00
as a special value for indicating not valid date.
If this was converted in PHP, unexpected things happen.
<?php
$s = "0000-00-00 00:00:00";
$d = \DateTime::createFromFormat('Y-m-d H:i:s',$s);
echo $d-> format("d.m.Y H:i:s");
// 30.11.-0001 00:00:00
?>
Available on https://3v4l.org/jnoIJ
----
Server IP: 45.112.84.4
Probable Submitter: 80.90.5.135 (proxied: 46.140.241.51)
----
Manual Page -- https://php.net/manual/en/book.datetime.php
Edit -- https://main.php.net/note/edit/126977
Del: integrated -- https://main.php.net/note/delete/126977/integrated
Del: useless -- https://main.php.net/note/delete/126977/useless
Del: bad code -- https://main.php.net/note/delete/126977/bad+code
Del: spam -- https://main.php.net/note/delete/126977/spam
Del: non-english -- https://main.php.net/note/delete/126977/non-english
Del: in docs -- https://main.php.net/note/delete/126977/in+docs
Del: other reasons-- https://main.php.net/note/delete/126977
Reject -- https://main.php.net/note/reject/126977
Search -- https://main.php.net/manage/user-notes.php