Parsing datetime from MySQL

Parsing datetime from MySQL

04-12-2010, 01:02 AM

[eluser]Zeeshan Rasool[/eluser]
In my blog, I use in my SQL query where i was using only month from date field:

Code:
WHERE MONTH(tbl_blog_post_data.blog_post_pub_date) = ".$month."

and if i need to get month as result then:

Code:
DATE_FORMAT(blog_post_pub_date, '%M') AS month

Hope it helps !

Messages In This Thread

Parsing datetime from MySQL - by El Forum - 04-11-2010, 06:15 PM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 12:46 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 12:55 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 01:02 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 07:23 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 07:30 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 07:34 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 10:01 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 10:19 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 04:59 PM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 05:12 PM

Parsing datetime from MySQL - by El Forum - 04-13-2010, 12:14 AM