note 125387 added to function.date

For users looking to format a unix timestamp with microseconds to mysql datetime, this function should do the trick: <?php function sqlDateTimeFromMicroTimestamp(int $microtimestamp):string{ $dt = new \DateTimeImmutable(); $normalTimestamp = (int)floor($microtimestamp / 1000000); $sqlTimestampWithoutMicroseconds = $dt->setTimestamp($normalTimestamp)->format('Y-m-d H:i:s'); $sqlTimestampWithMicroseconds = $sqlTimestampWithoutMicroseconds . '.'. ($microtimestamp % 1000000); return $sqlTimestampWithMicroseconds; } ?> ---- Server IP: 45.112.84.4 Probable Submitter: 185.85.3.172 (proxied: 145.131.96.178) ---- Manual Page -- http://php.net/manual/en/function.date.php Edit -- https://master.php.net/note/edit/125387 Del: integrated -- https://master.php.net/note/delete/125387/integrated Del: useless -- https://master.php.net/note/delete/125387/useless Del: bad code -- https://master.php.net/note/delete/125387/bad+code Del: spam -- https://master.php.net/note/delete/125387/spam Del: non-english -- https://master.php.net/note/delete/125387/non-english Del: in docs -- https://master.php.net/note/delete/125387/in+docs Del: other reasons-- https://master.php.net/note/delete/125387 Reject -- https://master.php.net/note/reject/125387 Search -- https://master.php.net/manage/user-notes.php