RE: [PHP-DB] Format of date retrieved from Oracle8
| From: | Marek Fábry | Date: | Tue, 02 Oct 2001 13:39:42 +0000 |
| Subject: | RE: [PHP-DB] Format of date retrieved from Oracle8 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12917@lists.php.net to get a copy of this message | ||
Just use SQL query like this:
"select to_char(date_in_db, 'DD.MM.YYYY HH24:MI') as d, next_column from table"
Marek F.
> -----Original Message-----
> From: Karsten Dambekalns [mailto:k.dambekalns@tu-bs.de]
> Sent: Tuesday, October 02, 2001 2:00 PM
> To: PHP Database
> Subject: [PHP-DB] Format of date retrieved from Oracle8
>
>
> Hi everybody,
>
> I have a PHP application using an Oracle database. This database has
> been built before the application was rewritten in PHP, so I couldn't
> switch to MySQL :-/
>
> Now the (small) problem is, in the database is a field of type DATE,
> which apparently stores the date _and_ time of the entry. The old
> application showed both date _and_ time, PHP just shows the date,
> using the exact same SQL.
>
> What might cause this, and how can I change this behaviour?
>
> TIA,
> Karsten