Change date stored as epoch to datetime when altering table?

[sKunKbad]

I am changing the name of one of the fields in my table:

 

ALTER TABLE `users` CHANGE `user_date` `created_at` DATETIME NOT NULL;

 

The old field, "user_date" is int(10) and storing time in epoch format. The new field is just a datetime field. Is it possible to modify this query so that the time is converted to datetime?

 

Thanks.

[requinix]

I suspect doing that will try to interpret existing data as YYYYMMDDHHMMSS strings, not as Unix timestamps.

 

Will definitely work: add the created_at column, UPDATE it using FROM_UNIXTIME(user_date), then drop user_date. Three statements.

[sKunKbad]

I suspect doing that will try to interpret existing data as YYYYMMDDHHMMSS strings, not as Unix timestamps.

 

Will definitely work: add the created_at column, UPDATE it using FROM_UNIXTIME(user_date), then drop user_date. Three statements.

 

Yep, this is what I ended up doing. I was just curious if there might have been a one liner way.