Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001041

Re: [PHP-DB] date_format for Oracle From: Joe Brown (joebrown <email protected>)
Date: 04/11/01

Also consider the oracle sql

ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

or whichever format you prefer.

This sets the default format returned when selecting a date column.

-Joe

"Steve Farmer" <hts <email protected>> wrote in message
news:p04320402b6fa8a7ffc70@[203.28.219.179]...
> Hi Richard,
>
> try TO_DATE or TO_CHAR , depending upon what you are trying to do,
> there are about 2 pages of formatting options for these functions.
>
> HTH
> Steve
> At 10:12 PM +0000 11/4/01, Richard Crawford wrote:
> >This isn't strictly a PHP question, I suppose... but is anyone aware of a
> >date_format function for Oracle comparable to MySQL's date_format()
function?
> >
> --
> ---------------------------------------------------
> "Minds are like parachutes, they work best when open"
> Support free speech; visit http://www.efa.org.au/
>
> Heads Together Systems Pty Ltd http://www.hts.com.au
> Email: hts <email protected> Tel: 612 9982 6767 Fax: 612 9981 3081
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>