How do I convert date to timestamp?

Anon

Hi,
I have a MySQL table, one of the columns in of type Date and is called date, another is of type Time and is called time (They are not storing the date and time of the row creation but of a cinema performance time).

I would like to be able to use the PHP date and time formating functions. I think that they take a variable of type timestamp and I would need to convert my columns into this type but I don't know how or if indeed this is the correct way.

Thank you for any help.
Eliot

Anon

You can let mySQL do the formatting with the appropriate query. Otherwise, PHP needs a timestamp, but I think in PHP4 there's a function that recognizes just about any type of US date format and you don't have to convert it to a timestamp first. Check the manual, it has many examples.

Anon

You can do this in either MySQL or PHP. I like to do it in mysql using the date_format() function. Check the mysql manual under date and time functions, chapter 7. this function will work on date, time, datetime, and timestamp columns.

You can also do "select unix_timestamp(date) as date1 from your_table" to get a unix timestamp that PHP can format. I'm not sure how that will return ifyou only have a date and a time column, though.

You'd be better off using Mysql's functions...

---John Holmes....