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:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
