Re: Format of date retrieved from Oracle8
| From: | Rouvas Stathis | Date: | Tue, 02 Oct 2001 14:28:37 +0000 |
| Subject: | Re: Format of date retrieved from Oracle8 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12920@lists.php.net to get a copy of this message | ||
Hi,
SELECT TO_CHAR(FIELD,'DD/MM/YYYY 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 (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
> --
> Why do we have to hide from the police, daddy?
> Because we use emacs, son. They use vi.
> -----------------------------
> mailto:k.dambekalns@tu-bs.de w³:
> http://www.k-fish.de/
> gpg: http://www.k-fish.de/mykeys.gpg
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net