|  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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
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-2024 The PHP Group
All rights reserved.
Last updated: Sun Jul 14 17:01:28 2024 UTC