Re: [PHP-DB] date_format for Oracle
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 + 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]
Re: [PHP-DB] date_format for Oracle
Also consider the oracle sql ALTER SESSION SET NLS_DATE_FORMAT='-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 + 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]
Re: [PHP-DB] date_format for Oracle
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='-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 + 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]