Correct time display of time taken from database cell

I am using a Microsoft access database to store entries for a photo album. The database has a separate cell with date of the pictures, in 01.12.99 format. I know that I can get around this issue by setting the field type to text instead of date, but I use the field for sorting. The PHP code displays the cell variable it pulls from the database ($Date) as 1999-12-01 00:00:00. I checked the internal PHP functions like Date, Mktime, etc, I don't think they handle this. Or am I wrong? Please help!
Stas

A very easy soultion is that you should change the date format in msaccess.
Go to design view and select the date format you want.
Other wise you will have to use mktime() funtion in Php for date formatting.


------------------
SR -
shiju.dreamcenter.net

"The fear of the LORD is the beginning of knowledge..."

Thanks for the advice, Shiju! I tried, but with no success - PHP seems to process the date in its own format independent of the format specified in the database. It still displays everything as 1999-12-01 00:00:00, though the date is in the short format in Ms Access (01.12.99). I asked on phpbuilder and they advised using:
eregi_replace("([0-9]{2})([0-9]{2})-([0-9]{2})-([0-9]{2})(.*)", "4.3.2", $Date);
How do I do this with mktime()? I doubt if eregi_replace() is a faster function.
Thanks in advance,
Stas