> -----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
this:
* 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
A_TABLE"
* 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'");
OCIExecute($stmt);
* 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
database!).
Cheers!
Mike
---------------------------------------------------------------------
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
Email: [EMAIL PROTECTED]
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
