Date/Time MS-Access Problem

[chuckb1300]

Hi Guys.

I found a post on this board for the EXACT problem that I am having, but I could not find the solution. Can someone help me out.

I am using PHP with a MS-Access database. When querying for a Date, i get a set of random numbers instead of a date value.
//*******************************
$sql = 'SELECT Event.evtDate,
Event.Type,
Event.Title,
Event.Desc,
Event.Link,
Event.ReqRSVP,
Person.firstName,
Person.lastName
FROM Event LEFT OUTER JOIN Person
ON Event.id_Person = Person.id_Person
ORDER BY Event.evtDate';
//****************************
<td><?= $rs->Fields['evtDate']->Value ?></td>
//*******************************
my date value should look somthing like "1/3/2005" , but instead reads "1104739200".

Any ideas??? PLEASE HELP

Thanx
Charles

[Frederick]

Read up here:
http://us4.php.net/manual/en/function.date.php

$datetime = date("m/d/y",$row["evtDate"]);