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" <[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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081
>>
>> --
>> 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]
--
---------------------------------------------------
"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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081
--
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]
