Posted by Captain Paralytic on 01/17/07 10:53

hennie wrote:

> How can i convert a date in text format into a date format that is accepted
> by msql?
>
> I have 3 values for day, month and year
>
> I combine them to a date string $date1=$year."-".$month."-".$day;
>
> How do i go further to make $date1 suitable for mysql?
>
> Thanks in advance, Hennie

Could you possibly reveal what format the data in the variables is in?
If year looks like 2006
and month looks like 05
and day looks like 09
then you are done.

[Back to original message]