Re: [PHP-DB] Format of date retrieved from Oracle8
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 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]
Re: [PHP-DB] Format of date retrieved from Oracle8
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 (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]
RE: [PHP-DB] Format of date retrieved from Oracle8
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 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
[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 -- 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]