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_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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to