convert date/time to unix timestamp

[webabolic]

How do I convert the following to a unix time stamp using maketime():

2004-07-11 10:47am -> unix timestamp

thanks

[rachel2004]

If that format you presented is the way it looks in a MySQL table, use the MySQL function UNIX_TIMESTAMP to do the conversion in this case:

SELECT UNIX_TIMESTAMP(datetime_column), etc.

[TheDefender]

Within php, use the strtotime() function provided the date is after Jan 1, 1970.