timestamp to datetime (mysql)

[Anon]

Hello all.

Im trying to copy data from a MSSQL database to a MySQL database. Im having probleme with a DATETIME field.

I managed to tranform the date into a unix timestamp, but Im not sure now how to instert it into the MySQL table.

I wish to keep the exact same format. In other words, I must enter each of those timestamp values into a DATETIME MySQL field, in short, from '1020310320' to 'YYYY-MM-DD HH:MM:SS'.

Thanks for any help !

[Anon]

<?
$date = '1020310320'; // UNIX timestamp
$date = date ('Y-m-d H:i:s', $date);
?>

$date is now in MySQL format ready to be inserted into your MySQL table

[mikikg]

Here is a function for time stam (UNIX & MySQL)

Simple use

echo formatDate($input);
or
echo formatUnixDate($input);

//#########################################################
// format the date correctly from MySQL timestamp
function formatDate($val)
{

if ($val==""){return "unknown";}

// split up the timestamp
$year=substr($val,0,4);
$month=substr($val,4,2);
$day=substr($val,6,2);
$hh=substr($val,8,2);
$mm=substr($val,10,2);
// convert it into a standard timestamp and format it
$date = date("d.M.Y H:i", mktime($hh, $mm, 0, $month, $day, $year));
return $date;}
//#########################################################

//#########################################################
// format the date correctly from UNIX timestamp
function formatUnixDate($val)
{

if ($val==""){return "unknown";}

$date = date("d.M.Y H:i", $val);
return $date;}
//#########################################################

[Anon]

see my new topic ... a problem still resides (mssql related i think).