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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
