Re: [PHP-DB] Getting a date out of oracle

2001-01-29 Thread Markus Fischer 

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: [EMAIL PROTECTED]
PGP Public  Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc
PGP Fingerprint: D3B0 DD4F E12B F911 3CE1  C2B5 D674 B445 C227 2BD0

-- 
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-DB] Getting a date out of oracle

2001-01-23 Thread Kallin Per 

Hi!
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.

Someone out there who can help me with this?

Please answer to me directly at [EMAIL PROTECTED] rather then to the list.


Yours,
Per Kallin, System developer
National Land Survey of Sweden
[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]