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:[EMAIL PROTECTED]]
> 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
Advertising
