Re: Date type: DATE

on 1/24/03 12:26 AM, amiller(at)hollywood101(dot)com purportedly said:

> $date = $year . "-" . $month . "-" . $day;
> insert into s_objetivos_caso values ($dni,$date,$cod_s_objetivos,$conn);
>
> or right in the the query itself...
>
> insert into s_objetivos_caso values ($dni,$year . "-" . $month . "-" .
> $day,$cod_s_objetivos,$conn);
>
> you would need to check that second way to be sure, but the first one will
> work for sure.

Neither of these will work, nor any previous suggestion, as date formats are
ambiguous and *must* be quoted:

$date = $year . "-" . $month . "-" . $day;
insert into s_objetivos_caso values ($dni,"'$date'", $cod_s_objetivos,$conn
);

This *will* work, at least as far as the date is concerned.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"