How to replace UNIX timestamp with mysql timestamp

[serverhenry]

I inherited a database that has a table of registration dates in unix format, for example 1200590610
, I want to change these dates to mysql timestamp format and insert them into a new table. I have a PHP script that does the conversion
<?php
$intime = (1200590610);
$read_in = date("Y-m-d H:i:s", $intime);
?>
The original table (members) has 3 fields: fn, ln, reg_date. reg_date is in unix format. I want to select the record, convert the date and insert it into a new table (mem) with the same 3 fields.
Can you help?

[NikhilJoshi]

Use a php loop that calls mysql_query() to go through the rows of the first table. For each row, use mysql_query() to insert column 0 and column 1 and the newly formatted date into the second table. In the following example, i just used FROM_UNIXTIME in its default format. You could use your function (or look at the formatting options of FROM_UNIXTIME, if you prefer to stick with something standard).

[mikechan12]

It is advisable change the SQL manually and use the FROM_UNIXTIME() operate to convert unix timestamp to MySQL timestamp format.

[nickypob]

i just used FROM_UNIXTIME in its default format