how to select foxpro Date thru php ?

[valen53]

i have a foxpro DB, i using ODBC to connect it.
I face a problem now, that is

$date = "2003-09-26" ;

$query = "SELECT id,name,resign FROM employee WHERE resignDate = '$date' "
$result = odbc_exec($pr, $query); 

i can't select out any result. b'cos the format $date incorrect to the foxpro DB .

anyone have solution to solve it ??
thank u