Error converting MySQL TIMESTAMP to DATETIME

Question

I have a table (example_table_1) which has a timestamp column declared as follows:

`ts1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

This MySQL statement generates a syntax error:

CREATE TABLE example_table_2 AS
SELECT DATETIME(ts1)
FROM example_table_1

How do I get my second table to have the TIMESTAMP data as a DATETIME column?

The specific error message that you're receiving would be very helpful. — Jericon
– Jericon, Commented Nov 6, 2011 at 10:00

Nicola Cossu · Accepted Answer · 2011-11-06 10:13:55Z

2

create table example_table_2 as
select cast(ts1 as datetime) as ts1
from example_table_1

answered Nov 6, 2011 at 10:00

Nicola Cossu

56.7k15 gold badges96 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1