Timestamp Problems

[SportinStyle]

For some reason my timestamps keep coming back

00-00-0000 00:00:00

I'm using the NOW() function when adding to database, as well as my column in mySQL is setup as timestamp (on addition: add timestamp).

Any ideas why?

[SportinStyle]

I figured it out myself, actually.

I had single quotes around my NOW() function... 🙂

BUT, Another question does come to mine. How do you format the date to go into the database and come out as "June 22nd, 2008".

I tried, DATE_FORMAT(%M, %d, #Y) but it didn't work out.

Should I replace NOW() with the above, and if so, how do I alter my database table to store this?

Thanks!

[dagon]

SELECT DATE_FORMAT(date_field, '%W %M %Y') as formated_date ...

[SportinStyle]

That gave me an error also.

Said improper function call, I believe.

[dagon]

please post the actual query you used and the error message received