Hi, I have the date format on my oracle server set to 'DD-MON-RR'. When I do a 'select' on SQLPLUS it shows me the date as '10/FEB/01', that's ok, but if I do the same 'select' on PHP it shows '10/02/01'.

I need PHP to show me the same result as Oracle does (without changing the PHP 'select').

Should I use 'puntenv' maybe?

Can anyone help me please?

    check oracle manuals about function TO_DATE() in sql/oracle.

    it should look like this

    birthdate=TO_DATE('$birthdate 00:00:00','DD/MM/YYYY HH24:MI:SS')

    hope this helps

      Write a Reply...