MySQL - Convert MM/DD/YY to Unix timestamp

Question

Is there an easy (single query) way to do this?

I'm reading those values from a column in a table and I think that the column itself is defined as a string (can't be helped, i'm afraid).

Answer 1

Use UNIX_TIMESTAMP;

SELECT UNIX_TIMESTAMP('2007-11-30 10:30:19');

Update:

SELECT UNIX_TIMESTAMP(CAST(fieldName AS DATE));

Answer 2

SELECT UNIX_TIMESTAMP(STR_TO_DATE('08/05/10','%m/%d/%y'));