Oracle date conversion
| From: | David C. Norris | Date: | Wed, 26 Dec 2001 17:00:03 +0000 |
| Subject: | Oracle date conversion | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15226@lists.php.net to get a copy of this message | ||
Oracle DATEs are retrieved (by ora_fetch_into($cursor, $row,
ORA_FETCHINTO_NULLS), for example) as plain dates (e.g., '26-DEC-01'),
losing the time of day (as in '26-DEC-01 12:34:56'). Is this a bug? Is
there a workaround that doesn't involve rewriting the query? (My
application is an SQL query window in the browser.)
I run Oracle 8.1.6 + Apache + PHP 4.0.6 + RH 7.1 on Intel.
Thanks,
David