Return an empty MySQL date field correctly

[tHud]

Hi,

In order to display dates in a readable format (when accessing MySQL) I use this little function...

 

function timechange($sqltime) {
return date ("d-m-Y", strtotime ($sqltime));
}

 

The only problem is, when the field is empty (0000-00-00) it returns 30-11-1999

 

Any thoughts on how I could correct this?

 

Thanks

[StathisG]

function timechange($sqltime) {
  if ($sqltime == '0000-00-00')
  {
    return 'whatever';
  }
  else
  {        
    return date ("d-m-Y", strtotime ($sqltime));
  }
}

[tHud]

Sigh...!

 

I had tried so many variants, the last of which was 

 

if (strtotime ($sqltime) == '0000-00-00') 

 

I think this shows a fundamentally flawed understanding on my part.

 

Thank you very much - your help is much appreciated.

 

Where do you guys learn php?

By yourselves?

Or at University?

 

Would love to know