Display Date |
[eluser]clintonbeattie[/eluser]
Hi, I've just started the development of a blog app (I know there's already a couple out there, it's for learning purposes). I haven't build the Admin area so I'm inserting content into phpmyadmin. My question is, how do I change the formatting of my date in the view. My date is in this format 2009-03-17. How do I get it to output as 17th March 2009 or any other of a variety of ways. Thanks so much. C
[eluser]pistolPete[/eluser]
Use a standard unix or mysql timestamps to store the date. Then you can use the Date helper to transform the date between different formattings.
[eluser]davidbehler[/eluser]
If you want to use mysql date/datetime columns, then you should have a look @ date_format()
[eluser]clintonbeattie[/eluser]
Hi, this is what I have. The first methos outputs the date as it is the the mySQL database, the second is trying to use the info you posted for me. echo "<p>".date('Y-m-d', strtotime($post['post_date'])) ."</p>"; echo DATE_FORMAT('2006-05-00', '%Y:%m:%d'); The second attempt here displays this error... Code: A PHP Error was encountered Any ideas? I'm baffled.
[eluser]clintonbeattie[/eluser]
Got it sorted. Amazing. Thanks so much. C One thing though. This is what I use... Code: echo "<p>".date('d M Y', strtotime($post['post_date'])) ."</p>"; If I change this to output the day with a suffix of, for example, 6th, 1st, it doesn't work. Here's my code... Code: echo "<p>".date('D M Y', strtotime($post['post_date'])) ."</p>"; This outputs the day as Mon, Tue etc and not 1st,3rd etc. Any help for this one?
[eluser]xwero[/eluser]
[quote author="modelreject" date="1237313567"] echo DATE_FORMAT('2006-05-00', '%Y:%m:%d'); [/quote] 00 is not a valid day
[eluser]clintonbeattie[/eluser]
Still doesn't work, even with ‘2006-05-02’. Mmmmm
[eluser]xwero[/eluser]
hum, DATE_FORMAT is a mysql function not a php function. |
Welcome Guest, Not a member yet? Register Sign In |