[digitalje5u5]

I am wanting to convert a date that one enters in a form into a date field in a table. When the field is set as a date, it does not want to accept the date from the form. If I set the type to varchar, etc it works.

I am pretty sure this is a formatting error, but I am lost as how to go about this.

As it stands, I have the date format as 5/24/2004 in the form. How would I strip the "/" and reformat the input so that mySQL understands this?

THanks,

/DJ

[dawggy505]

Originally Posted by digitalje5u5

I am wanting to convert a date that one enters in a form into a date field in a table. When the field is set as a date, it does not want to accept the date from the form. If I set the type to varchar, etc it works.

I am pretty sure this is a formatting error, but I am lost as how to go about this.

As it stands, I have the date format as 5/24/2004 in the form. How would I strip the "/" and reformat the input so that mySQL understands this?

THanks,

/DJ

i would use the ASCII character set (ex. a space is %20)

[digitalje5u5]

Originally Posted by dawggy505

i would use the ASCII character set (ex. a space is %20)

care to elaborate?

/DJ

[digitalje5u5]

bump the wax tadpole

[blaw]

Hi there,

MySQL Date type accepts a string like "2004-05-28" if I recall correctly. So if your input is like "05/28/2004", you can convert this into the correct format.

You can do either of the following (or more):

1) explode() it with "/" and build the correct date format,
2) substr() to extract each component and glue them together, or
3) strtotime() it to onvert it first to UNIX timestamp and use date() to make the correct format out of it.

If you need an example, you can visit http://wwwphp.net and type in the function of your choice. Good luck then!

[cheesehead]

Originally Posted by digitalje5u5

I am wanting to convert a date that one enters in a form into a date field in a table. When the field is set as a date, it does not want to accept the date from the form. If I set the type to varchar, etc it works.

I am pretty sure this is a formatting error, but I am lost as how to go about this.

As it stands, I have the date format as 5/24/2004 in the form. How would I strip the "/" and reformat the input so that mySQL understands this?

THanks,

/DJ

You can use strtotime function of PHP to convert the date from the form field to an internal UNIX time. Then store that time into an Integer field.

int strtotime ( string time [, int now])

<?php
$str = 'Not Good';
if (($timestamp = strtotime($str)) === -1) {
echo "The string ($str) is bogus";
} else {
echo "$str == ". date('l dS of F Y h:i:s A',$timestamp);
}
?>

When you want to format the internal date back to a formatted date to output to the html page then use the "date" function.

Hope this helps.