retrieving 'intervall Day' dataype from oracle db with php

hi,

I have an oracle column wich is of "INTERVAL DAY (1) TO SECOND (0)" type and I would like to retrieve data from it thanks to php. I tried something like : "select to_char(column) " but it doesn't give me any result :
These instructions don't give errors, but neither results :

$cursor = ora_open($id_connect);
if (ora_parse($cursor, $sql))
 if(!ora_exec($cursor))
   echo "problem d'exec sur sql";

$ncols = ora_numcols($cursor);// => give me =1
$nrows = ora_numrows($cursor);// => give me =0

Does anyone have an idea about what is going on ? And how can I retrieve data from an oracle "INTERVAL DAY" column ?

Any help welcome.
Regards.
JR. Received on Thu Aug 19 2004 - 11:19:33 CDT