[Resolved] Break apart mysql date with php

[anorman]

I want to break apart a date entered into a mysql database, for editing purposes. So a date such as 2004-06-05, I want to be able to get the year, month and day seperately. Is there a php function that can do this?

Thanks,
Norman
www.jackasslinux.com

[rachel2004]

http://www.php.net/manual/en/function.date.php

[anorman]

Those functions seem fine for the current date, or the timestamp from a system. But I can't quite seem to get them to work for a date stored in a database.

Thank,
Norman

[adi]

Let's say in mysql you have the signup date stored in yyyy-mm-dd format and you want to retrieve the signup date for the user with user_id=1 and split it into year , month and day.

<?php
include ("conect.php");
$user_id="1";
$sql=mysql_query("SELECT signup_date  FROM users 
                                WHERE user_id='$user_id' ");
while ($row=mysql_fetch_array($sql))
      {
           $signup_date=''.$row['signup_date'].'';
      }   

$date_array=explode ("-",$signup_date);
$year=$date_array[0];
$month=$date_array[1];
$day=$date_array[2];
?>

[anorman]

Much appreciated, just what I wanted!

Thanks,
Norman

[rachel2004]

To do it with PHP's date function:

<?php
$today = "2004-07-06";

$sql = "SELECT UNIX_TIMESTAMP(my_date_column)
        FROM my_table
        WHERE my_date_column = '$today'";

$result = mysql_query($sql, $db_connection);

$row = mysql_fetch_array($result);

$month = date('F', $row['UNIX_TIMESTAMP(my_date_column)']);
$date  = date('j', $row['UNIX_TIMESTAMP(my_date_column)']);
$year  = date('Y', $row['UNIX_TIMESTAMP(my_date_column)']);

echo "In Europe, today is: ".$month." ".$date.", ".$year;
?>

[adi]

You're welcome!