> -----Original Message-----
> From: maxim [mailto:[EMAIL PROTECTED]]
> Sent: 23 May 2002 17:00
> 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 default format for dates returned from Oracle tends to be something like 
'DD-MON-YY', thus giving only a short-form date.  There are several ways of changing 

  * Use the TO_DATE function in your select, e.g.
        $sql = "select TO_DATE(A_DATE, 'DD-Mon-YYYY HH24:MI:SS') as DATE_TIME from 

  * Use ALTER SESSION to set the default format for the current session (NOTE: I 
haven't tried this (yet!)):
        $stmt = OCIParse("ALTER SESSION SET NLS_DATE_FORMAT = 'DD-Mon-YYYY HH24:MI'");

  * Change the default value of the Oracle initialization parameter NLS_DATE_FORMAT (I 
haven't tried this either, as I don't have administrative control of my Oracle 



Mike Ford,  Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Beckett Park, LEEDS,  LS6 3QS,  United Kingdom
Tel: +44 113 283 2600 extn 4730      Fax:  +44 113 283 3211 

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

Reply via email to