mysql日期截取年月,从MYSQL上的时间戳提取日/月/年

I have :

$date = $actualite['date'];

$actualite['date'] is a TIMESTAMP

And I was wondering how can I extract from this timestamp the day, then the month, then the year in 3 variables.

Thank you for your help :)

解决方案

Use date_parse($actualite['date']);, which will return an array containing the day, month, year and other items.

Example:

print_r(date_parse("2006-12-12 10:00:00.5"));

?>

Output:

Array

(

[year] => 2006

[month] => 12

[day] => 12

[hour] => 10

[minute] => 0

[second] => 0

[fraction] => 0.5

[warning_count] => 0

[warnings] => Array()

[error_count] => 0

[errors] => Array()

[is_localtime] =>

)