 |
 |
Find a programming school near you
php-db | 2001041
Date: 04/11/01
- Next message: Yasuo Ohgaki: "Re: [PHP-DB] create type"
- Previous message: Paul Burney: "Re: [PHP-DB] select substring_index"
- In reply to: Joe Brown: "Re: [PHP-DB] date_format for Oracle"
- Next in thread: Brian S. Dunworth: "Re: [PHP-DB] date_format for Oracle"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi Joe,
Yes, I put this in as a standard statement immediately after i
connect to the orcale database, it is also possible to put it in your
init.ora file i believe
rgds
Steve
At 8:28 PM -0400 11/4/01, Joe Brown wrote:
>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>
-- --------------------------------------------------- "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>
- Next message: Yasuo Ohgaki: "Re: [PHP-DB] create type"
- Previous message: Paul Burney: "Re: [PHP-DB] select substring_index"
- In reply to: Joe Brown: "Re: [PHP-DB] date_format for Oracle"
- Next in thread: Brian S. Dunworth: "Re: [PHP-DB] date_format for Oracle"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
