Date retrieval from Access 2003

[austine_power007]

I am using PHP and Microsoft Access 2003 i store date field as a short date.........but when i retrieve data from Access 2003 it shows me something like

2006-11-30 00:00:00

I retrieved the date from database and stored the date into a variable names $date .......I just want the date as mm/dd/yy ....How can i do that please help me.  ???

[craygo]

Use the date function.
[code]<?php
$fdate = $myvarname;
$date = date("m/d/y", strtotime($fdate));
?>[/code]

Ray

[austine_power007]

[quote author=craygo link=topic=116976.msg476987#msg476987 date=1164983387]
Use the date function.
[code]<?php
$fdate = $myvarname;
$date = date("m/d/y", strtotime($fdate));
?>[/code]

Thanks a lot man it helps me a lot .........

Ray
[/quote]