Member Avatar for derekcpt

Hi,

Could someone assist me here ;-) (Again)

I am recording dates into a mysql database in the following forma:

YYYY-MM-DD
2008-08-17

date('Y-m-d')

Now, I have to get data from my mysql database, but the data has to be filtered by the month and year. So, in other words, if I have a date in the YYYYMMDD format, how do I get php to read the month and year only, from the date?

So if I have the date 2008-08-17 in my database, how do I get php to tell me that the month is 08/August and the year is 2008?

Thanx.

  • 2 Contributors
  • 3 Replies
  • 206 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by R0bb0b
Member Avatar for R0bb0b 
<?
$mysql_date = "2008-08-17";
list($y, $m, $d) = explode("-", $mysql_date);
echo date("m/d", mktime(0, 0, 0, $m, $d, $y));
?>
Member Avatar for derekcpt

tttthhhaaannnkkk yyyooouuu!!!!!!!

So much!

Member Avatar for R0bb0b

no problem.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.