you can look here: http://technet.oracle.com/doc/oracle8i_816/server.816/a76966/ch2.htm
Michael "Maxim" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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