Retrieving a date from Oracle. Please help!
| From: | maxim | Date: | Thu, 23 May 2002 15:59:34 +0000 |
| Subject: | Retrieving a date from Oracle. Please help! | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19394@lists.php.net to get a copy of this message | ||
Hi all!
The problem is I can't get expected datetime value from SELECT query on
Oracle table that has a field of type DATE. Seems like datetime looses its
time part.
The code is like as follows:
...
$sql = "select * from A_TABLE";
ora_parse($curs, $sql);
ora_exec($curs);
...
ora_fetch_into($cursor, $r, ORA_FETCHINTO_NULLS);
foreach ($r as $key => $value) {
print "$key => $value <br>\n";
}
...
This displays date part only. May be special PHP or Oracle ini parameters or
environment vars required? Any help appreciated.
--------------------------------
Best regards,
Maxim Bubnov,
Software Engineer,
Stelt Telecom NN