Re: [PHP-DB] Oracle date conversion

2002-01-11 Thread David C. Norris
suggest, but my application is an SQL query window in the browser, aimed at users who are not SQL enthusiasts. Thanks again, David Ford, Mike [LSS] wrote: -Original Message- From: David C. Norris [mailto:[EMAIL PROTECTED]] Sent: 26 December 2001 17:00 Oracle DATEs are retrieved

[PHP-DB] Oracle date conversion

2001-12-26 Thread David C. Norris
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