 |  |  |  |  |  |  |  |
MySQL Timestamp into PHP Format
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Dec 2004
Posts: 234
Reputation: 
Solved Threads: 0
Posting Whiz in Training
I have a timestamp column in a mysql table.
Using PHP, how do I convert the timestamp format which is "YYYY-MM-DD HH:MM
S" into a format like "March 16 2008, 08:41 am" ?
Please help
Thanx
Using PHP, how do I convert the timestamp format which is "YYYY-MM-DD HH:MM
S" into a format like "March 16 2008, 08:41 am" ?Please help
Thanx
basically there are two ways of solving it. The first is the explode the data into chunks and then converting them.
secondy, in my opinion the better and easier way:
use the function date("prefered format",mktime(...))
first arguments is you format that you like.
the secend argument created an unix-timestamp (look at http://de2.php.net/manual/en/function.mktime.php). it allows you to generate any date and time you like.
secondy, in my opinion the better and easier way:
use the function date("prefered format",mktime(...))
first arguments is you format that you like.
the secend argument created an unix-timestamp (look at http://de2.php.net/manual/en/function.mktime.php). it allows you to generate any date and time you like.
|
Similar Threads
- csv, convert date, mysql, php (PHP)
- php mysql question (PHP)
- MySQL date formatting (PHP)
- Login Security ! (PHP)
Other Threads in the PHP Forum
- Previous Thread: Generate static html page
- Next Thread: forum login
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
apache api array basic beginner binary broken cache cakephp checkbox class cms code computing confirm cron curl customizableitems database date delete display dynamic echo email error external file files filter folder form forms forum function functions gc_maxlifetime google headmethod host howtowriteathesis href htaccess html iframe image include insert ip javascript joomla limit link login mail malfunction memmory memory menu mlm multiple mysql navigation oop parsing paypal pdf php phpmysql problem query question radio random recursion remote script search select server sessions sms snippet source space sql syntax system table thesishelp trouble tutorial update upload url validator variable video web youtube
