|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #46383 Additional date/time functions
Submitted: 2008-10-24 23:15 UTC Modified: 2017-01-11 16:12 UTC
From: zoe at monkeehouse dot com Assigned:
Status: Wont fix Package: Date/time related
PHP Version: * OS: *
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Bug Type:
From: zoe at monkeehouse dot com
New email:
PHP Version: OS:


 [2008-10-24 23:15 UTC] zoe at monkeehouse dot com
Two PHP functions that replicate the MySQL functions of the same name.  These may be useful to other people given how popular the combination of PHP and MySQL is.

Reproduce code:
function time_to_sec($time) {
	$hours = substr($time, 0, -6);
	$minutes = substr($time, -5, 2);
	$seconds = substr($time, -2);

	return $hours * 3600 + $minutes * 60 + $seconds;

function sec_to_time($seconds) {
	$hours = floor($seconds / 3600);
	$minutes = floor($seconds % 3600 / 60);
	$seconds = $seconds % 60;

	return sprintf("%d:%02d:%02d", $hours, $minutes, $seconds);


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2011-01-02 01:59 UTC]
-Package: Feature/Change Request +Package: Date/time related -Operating System: +Operating System: * -PHP Version: 6CVS-2008-10-24 (CVS) +PHP Version: *
 [2017-01-11 16:12 UTC]
-Status: Open +Status: Wont fix
 [2017-01-11 16:12 UTC]
This issue is by now open for more than 8 years. And as the two functions can easily be created in userland I'm closing this.

Feel free to reopen should the need arise.
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Wed Sep 23 04:01:25 2020 UTC