Re: Retrieving a date from Oracle. Please help!

you can look here: http://technet.oracle.com/doc/oracle8i_816/server.816/a76966/ch2.htm Michael "Maxim" <d17@softhome.net> schrieb im Newsbeitrag news:20020523155828.73370.qmail@pb1.pair.com... > 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 > >