Display a mysql DATE (yyyy-mm-dd) as dd Month yyyy

My MySQL database stores dates using the DATE datatype yyyy-mm-dd

I need to display the date on my site as, eg: 27th Jan 1985.

If no dd or mm is present (eg: 1985-00-00) then it should display only the year, eg: Date: 1985.

If no dd is present, but mm and yyyy are (eg: 1985-01-00) then it should display as: Date: January 1985

If no date has been entered, (eg: 0000-00-00) it should display text saying "Coming Soon".

Whenever a year is shown I need an "a href" wrapped around it so that I can create a link myself later.

Skills: MySQL, PHP

See more: month yyyy mysql, january is month, create mysql database using php, mm, display, date, display mysql, datatype, mysql link, create date, create mysql database, mysql display, php mysql create database, 2011 text, year 2011, mysql date, 0000, link mysql, date site create, display mysql date, php mysql year, link mysql database, mysql link database, text database mysql, display mysql date php

About the Employer:
( 3 reviews ) Harray, United Kingdom

Project ID: #903053

Awarded to:


dear sir. I can do it within a few hours. Please contact me.

$30 USD in 0 days
(0 Reviews)

Hi sir, let me do it now! thanks, kimi.

$30 USD in 1 day
(133 Reviews)

5 freelancers are bidding on average $36 for this job


I am a expert php / mysql, please read the private message.

$30 USD in 0 days
(20 Reviews)

hi sir Please check pm

$40 USD in 0 days
(7 Reviews)

Dear sir! I have many experience work of this type and I'am ready to work your project. Please give me details. Regards.

$50 USD in 2 days
(2 Reviews)