Convert date to Unix timestamp

Question

I have a table in a Mysql database that has a date column VARCHAR, guy 20-09-2017 and I need to migrate this column to a column bigint(8) using the date format timestamp unix.

How to do this?

Answer 1

UNIX_TIMESTAMP('2017-09-20 00:00:00')

Documentation.

If it is in another format, then you have to format it first:

STR_TO_DATE('20-09-2017', '%d-%m-%Y')

I put in the Github for future reference.

Answer 2

Follow the solution I used.

Converting from string to date:

Update `tabela` 
set date = STR_TO_DATE(date_text, '%d/%m/%Y')

Converting from date to Unix timestamp:

Update `tabela`
set date_unix = UNIX_TIMESTAMP('date');