Bug #9902 Updated: Converting to/from mysql timestamp

ID: 9902 Updated by: georg@php.net Reported By: mail@scottbrinker.com -Status: Open +Status: Bogus Bug Type: Feature/Change Request Operating System: Red Hat Linux 7.x PHP Version: 4.0.4pl1 New Comment: It's make no sense to have this functionality on the client side, if the server side supports it already. Use the MySQL Functions DATE_FORMAT, TIME_FORMAT and UNIX_TIMESTAMP for converting timestamp fields. If you need some more special functions, you can also extend MySQL with an additionally UDF. Previous Comments: ------------------------------------------------------------------------ [2001-03-21 11:56:06] mail@scottbrinker.com I propose some new functions for those of us that use PHP and mySQL together on a daily basis... I would suggest a function that acts like getdate() which produces an array of time and date data from a mySQL timestamp (YYYYMMDDHHMMSS). Along these lines, functions which convert between a unix timestamp and a mySQL timestamp would be useful. Surely I'm not the only one that has to include my own custom functions to produce these results. Having standard distribution-based versions of these functions would make my and others work a lot easier. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=9902&edit=1