How to capture, convert and store date/time info

[hubbardude]

On a website I'm building I have a javascript date/time picker, which is one field with all the info, i.e. 01/10/2008 10:30 p.m. It's used to enter the date of an event. What I would like to happen is compare the date the user entered to the current date, so that if the date occurs after the current date, the event listing is removed from the website.

My main question is, should I try to capture the data in the exact same format which it's going to be stored in inside the db, or should I try to capture it in one way and transform it?

[wilku]

If you've got well formated time string (like the one you showed) you can always convert it to timestamp using [man]strtotime[/man]. Keep in mind that on 32bit systems timestamp will stop working in the 2030's (I don't remember the exact date).
The timestamp can be converted to whatever db format is required by your database using [man]date[/man] .