php / mysql获取日期格式

Question

i'm compiling a church register and the dates are in this format yyyy-mm-dd example. 1978-03-27 .I need to make it 27th March,1978. Any php script to help me out? I tried MSEXcel but messes it up. thanks (anyway..i'm getting it from a database) so i would be glad if i have it been read from a database or a file of dates.

Answer 1

Try with:

$input     = '1978-03-27';
$timestamp = strtotime($input);
$output    = date('dS F, Y', $timestamp);

Reference to date format: php.net