formatting date for mysql problem.

Hello all,

I seem to be having trobule putting a date into mysql's timedate format field.

When the user submits the form, I get the variables:

viewyear
viewmonth
viewday
(hour,minute,second not relevant so could be all 0's if needed)

This is when the user wants the view and is NOT today's date.

I was thinking of putting it in a variable like:
"20020417000000"

Any help on how to get this in and out of mysql?

Thought I was on the right path but I must be missing something.

Thanks

"hour,minute,second not relevant"

Then you need a DATE time, not TIMESTAMP nor DATETIME

Either way you can input the date as text: "YYYY-MM-DD"

Don't forget to add leading zeros for month and day if less than 10. mysql wants 2002-01-21 NOT 2002-1-21.

Cheers,

Cris

ok so I make a DATE field and enter date like:
2002-02-03

Now. When I want the last 5 results based on date do I need to do anything special besides ORDER BY viewdate DESC ??? And limit 5 of course.

THaNKS!

Yes, that will work. A date, time or timstamp field is properly handled by ORDER BY in mysql.

Cheers,

Cris