> Thanks for your response.  When I use SQL*Plus, I get full
> date+time.  I also get a full datetime from cx_Oracle (a
> Python module).  Is this then a default _PHP_ behavior when
> querying an Oracle db?  Why not return the full info?
> Ordinarily, I would not complain about the small rewrite you
> suggest, but my application is an SQL query window in the
> browser, aimed at users who are not SQL enthusiasts.
>

Another option is to alter your NLS_DATE by setting it in init.ora
(proabably not a good idea) or using "ALTER SESSION" which while not ideal
would certainly stop you having to rewrite the query.
As David pointed out though, using TO_CHAR and it's mate TO_DATE is by far
the best way to go.

Cheers,
 Graeme


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to