Hi,
ALTER SESSION SET NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
bye,
maxim wrote:
> 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
>
>
>
--
--
--------------------------------------
E-mail: [EMAIL PROTECTED]
----------------------------
JAWA Management Software GmbH
Liebenauer Hauptstr. 200
A-8041 GRAZ
Tel: ++43-(0)316-403274-12
Fax: ++43-(0)316-403274-10
GSM: ++43-(0)676-93 96 698
homepage: http://www.jawa.at
--------- privat -----------
E-mail: [EMAIL PROTECTED]
homepage: http://www.inode.at/mbretter
--------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
