Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived Development & Programming Need help printing formatted mysql datetime field
Need help printing formatted mysql datetime field
  • El Forum
    Unregistered
  •  
#6
04-28-2009, 04:15 AM

[eluser]Zeeshan Rasool[/eluser]
Did you try like this:

Code:
"Select blog_id,DATE_FORMAT(post_pub_date, '%M %d %Y') AS post_pub_date,blog_name
from Blogs";
direct get formatted date from db.


Messages In This Thread
Need help printing formatted mysql datetime field - by El Forum - 04-27-2009, 10:59 PM
Need help printing formatted mysql datetime field - by El Forum - 04-27-2009, 11:03 PM
Need help printing formatted mysql datetime field - by El Forum - 04-27-2009, 11:21 PM
Need help printing formatted mysql datetime field - by El Forum - 04-28-2009, 01:55 AM
Need help printing formatted mysql datetime field - by El Forum - 04-28-2009, 02:24 AM
Need help printing formatted mysql datetime field - by El Forum - 04-28-2009, 04:15 AM
Need help printing formatted mysql datetime field - by El Forum - 05-01-2009, 09:59 AM
Need help printing formatted mysql datetime field - by El Forum - 05-02-2009, 06:36 AM
Need help printing formatted mysql datetime field - by El Forum - 05-02-2009, 06:46 AM
Need help printing formatted mysql datetime field - by El Forum - 05-03-2009, 10:57 PM



Theme © iAndrew 2016 - Forum software by © MyBB