[Oracle] parsing date in query

[Anon]

Hi,

Does anyone know what is wrong with this script?

$today = '1/1/2000';
$name = 'jwmaarse';
$connection = 'OCILOGON("TEST","TEST","TEST");

$query = "INSERT INTO MYLOG (NAME, LAST) VALUES ('$today','$name')";
$stmt = OCIParse($connection,$query);
OCIExecute($stmt);

This will give the error:
"not a valid month"

When I change today to '1 jan 2000' this problem is solved, but the Oracle says it is a wrong date.

[Anon]

If NAME is a datefield you must supply the date in the format specified in your Oracle language settings. In the registry : Key NLS_LANG value (on my system) AMERICAN_The Netherlands.WE8ISO8859P1.

In order to avoid confusion I use Oracle TO_DATE function. To format a dat from the database you can use TO_CHAR function. Look into your Oracle docs.

$day = 22;
$month = 8;
$year = 2001;

$DATUM=$day."/".$month."/".$year;

In your SQL :
DATEFIELD = TO_DATE('$DATUM','dd/mm/yyyy')

good luck/succes,

Jan

[Anon]

bedankt ;-)