 |  |  |  |  |  |  |  |
reformatting MySQL date (yyyy-mm-dd)
 |
•
•
Join Date: May 2005
Posts: 232
Reputation: 
Solved Threads: 0
Posting Whiz in Training
Hey, I need help getting that ugly yyyy-mm-dd format to change to something prettier. I would prefer being able to output it in the form like January 01, 2007. Something easy to read for the average user. I can leave it stored in yyyy-mm-dd in my database, but in my output I'd like to reformat it.
Any pointers?
Any pointers?
•
•
Join Date: May 2005
Posts: 232
Reputation:
Solved Threads: 0
Posting Whiz in Training
Thanks, I have used that function before, but it seems that I can only format the current system time with that function. How can I take a previous date/time recorded in a database and use this fuction with it?
•
•
Join Date: May 2005
Posts: 232
Reputation:
Solved Threads: 0
Posting Whiz in Training
Well, after some searching around, I found this bit of code that can be used in the SELECT function that works for me:
[PHP]
SELECT date_format(my_date, '%M %e, %Y') as date, FROM my_table
[/PHP]
It then stores the date in the format I want in the variable called "date".
Thanks.
[PHP]
SELECT date_format(my_date, '%M %e, %Y') as date, FROM my_table
[/PHP]
It then stores the date in the format I want in the variable called "date".
Thanks.
Last edited by nathanpacker; Jan 6th, 2007 at 7:46 am.
•
•
Join Date: May 2005
Posts: 232
Reputation:
Solved Threads: 0
Posting Whiz in Training
•
•
•
•
Originally Posted by php_daemon 
Or in php:
[php]
echo date('Y m d',strtotime($mysqldate));
[/php]
•
•
•
•
Originally Posted by nathanpacker
Where is this pulling the date from?
Last edited by php_daemon; Jan 6th, 2007 at 6:35 pm.
•
•
Join Date: May 2005
Posts: 232
Reputation:
Solved Threads: 0
Posting Whiz in Training
•
•
•
•
Originally Posted by php_daemon
This is assuming you've a date already fetched from a database to $mysqldate.
•
•
•
•
Originally Posted by nathanpacker
Ah, so I can pull the date from the database, and put it in a variable, say $mysqldate, and then use that to format it? That's even easier! Thanks!
•
•
Join Date: May 2005
Posts: 232
Reputation:
Solved Threads: 0
Posting Whiz in Training
•
•
•
•
Originally Posted by php_daemon
Yes, exactly. Although there's no difference as far as the performance is concerned, personally I prefer to leave the data formatting to php rather than mysql, simply for the sake of responsibility separation.
|
Other Threads in the PHP Forum
- Previous Thread: How do i display records of an item into textbox based on drop down list
- Next Thread: php and dom? (dommitall).
Views: 7110 | Replies: 10
| Thread Tools | Search this Thread |
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for PHP
access ajax apache array beginner box buttons cakephp check checkbox class cms code cookies database date delete directory display download dropdown drupal dynamic echo email error file files folder form forms function functions header hosting href htaccess html image images include insert ip java javascript joomla jquery limit link list login loop mail menu methods mlm mod_rewrite multiple mysql order parse password paypal php problem query radio random redirect regex remote results script search security select server session sessions shopping soap sort sorting source sql string system table unicode update upload url user validation variable video web website wordpress xml
