RE: [PHP-DB] Format of date retrieved from Oracle8

2001-10-02 Thread Marek Fábry
Just use SQL query like this: select to_char(date_in_db, 'DD.MM. 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

Re: [PHP-DB] Format of date retrieved from Oracle8

2001-10-02 Thread Rouvas Stathis
Hi, SELECT TO_CHAR(FIELD,'DD/MM/ HH24:MI:SS') FROM TABLE -Stathis. Karsten Dambekalns wrote: 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

Re: [PHP-DB] Format of date retrieved from Oracle8

2001-10-02 Thread Karsten Dambekalns
On Tue, Oct 02, 2001 at 03:39:42PM +0200, Marek Fábry wrote: Just use SQL query like this: select to_char(date_in_db, 'DD.MM. HH24:MI') as d, next_column from table Thanks, works perfectly :-) Karsten -- Why do we have to hide from the police, daddy? Because we use emacs, son. They use