MySQL startDate Field

[neptune]

I am creating a custom list of events on my home page from the data in the epc_calendar table. However, I am having trouble with the startDate field, as it appears to be encrypted.

How do I convert the startDate to yyyy-mm-dd (or any other understandable) format?

I'm pretty new to PHP and mySQL, so please bear with me.

[Brian]

That is a Julian Day Number.

http://us2.php.net/manual/en/function.juliantojd.php

[neptune]

Thanks for the tip! Here's my solution, if anyone else is curious:

It shows the date in this format mm.dd.yyyy

<?php
$mydate = jdtogregorian($row['startDate']);
?>
<?=date("m.d.Y", strtotime($mydate));?>

(I am looping, which is why my startDate variable looks like $row['startDate'])