Re: Getting a date out of oracle

On Tue, Jan 23, 2001 at 04:30:21PM +0100, Kallin Per wrote : > I'm pretty new to PHP and now I got a problem with Date datatype and oracle. > I can recive the date as a string with osiresult($stmt, "COLUMN_NAME") in > the oracle date format (eg. '23-JAN-01') but I wold like to recive the whole > date (eg. '2001-01-23 15:21:13'), that's the first problem. > The second problem is to convert this string into datatype date in php so I > can use the setlocale() function on it. Here are some examples [1] for working with Oracle dates. m. [1] http://www.camden.rutgers.edu/HELP/Documentation/Oracle-class/dates.html -- Markus Fischer, http://josefine.ben.tuwien.ac.at/~mfischer/ EMail: mfischer@josefine.ben.tuwien.ac.at PGP Public Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc PGP Fingerprint: D3B0 DD4F E12B F911 3CE1 C2B5 D674 B445 C227 2BD0