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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php