Convert unix time to normal time from while copying data from mysql data files to sql server 2005

Follow the steps mention in posting,

“Sunday, March 23, 2008
Copy data from mysql data files to sql server 2005 “

Until “Again next and write sql query to get data. (table by table)”

This step when you select data you can use “FROM_UNIXTIME” and convert unix time to normal time.

For Eg:

Without considering the unix time here is the SQL script,

select`id`,`time`,`userid`,`ip`,`course`,`module`,`cmid`,`action`,`url`,`info`

from mdl_log_sem1

Considering the unix time here is the SQL script,

select `id`,FROM_UNIXTIME(`time`),`userid`,`ip`,`course`,`module`,`cmid` ,`action`,`url`,`info`

from mdl_log_sem1

Here simply use as FROM_UNIXTIME(`time`)

time- name of the field

then other steps are same as in the previous posting.

convert unix_timestamp to normal date value

mysql>

SELECT FROM_UNIXTIME(875996580);

Result=>
FROM_UNIXTIME(875996580)
1997-10-04 13:23:00

SELECT FROM_UNIXTIME(875996580) + 0;

Result=>
FROM_UNIXTIME(875996580) + 0
19971004132300.000000

SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(),'%Y %D %M %h:%i:%s %x');

Result=>
FROM_UNIXTIME(UNIX_TIMESTAMP(),'%Y %D %M %h:%i:%s %x')
2007 22nd July 07:46:11 2007