Re: Oracle + NLS_DATE_FORMAT

On Monday 19 May 2003 07:57, Vaughn, Paul wrote: > Oracle has a TOCHAR and TODATE function, which my help in what you are > trying to do. Simply "force" the date in your query to the format you want > it in. You can find out more with a simple google search on these terms. > > TO_DATE('01-FEB-2002' ,'dd-mon-yyyy') > > - Paul I can't do that, because, i *need* to do a select * and I don't know how many or what type of field im getting, any other ideas?? j0rd1 > > Hello > > I have put NLS_DATE_FORMAT in my client machine (Linux) to be YY-MM-DD, but > when I use PHP, i get dates in the YY-mon-DD format > > I tried using putenv('NLS_DATE_FORMAT="DD-MM-YYYY HH24:MI:SS"'); > I added export NLS_DATE_FORMAT="DD-MM-YYYY HH24:MI:SS" to > /usr/sbin/apatchectl > and restarted Apache > I tried using NLS_DATE_FORMAT as a global variable for my whole system and > still nothing > I tried using > $stmt = OCIParse($conn, > "ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY > HH24:MI:SS'"); > OCIExecute($stmt); > > and yet... nothing > > any ideas? > > > j0rd1