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


Reply via email to