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
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
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