Date type problem with PHP/MSSQL

Anon

Hello all.

Thanks for the ppl who helped me out in my last post. It seams I still have problems with the datetime field, but the problem seams to be related to the fact that I use PHP to extract data from a MSSQL table, that I wish to copy AS IS, in a MySQL table (so keep the DATETIME format intact).

Here are the facts.

The MSSQL datetime format is as follows ;

'2002-05-01 23:32:28.000'

Now, if I simply output this date using mssql php functions, i'll automatically get the formated date ;

'May 1 2002 11:32PM'

Oops, im missing the seconds here !! Even if I use the php function strtotime(), i'll get a false unix timestamp, and im screwed.

Anyone can help please ?!?

johnh

So if I understand you correctly, you want to leave the mySQL timestamp, and just show it differently in your php scripting?

If that's the case, an easy solution is to explode the date by - and or by : and set them into an array for output as you want them displayed.

John

But there are other ways aswell, like some date time conversion stuff.

Anon

Thanks for the reply John.
No, that not what im trying to do.

Im trying to get a DATETIME field from a mssql database, and export it as is in a mysql database.

For instance, one datetime field from a mssql database looks like this ;
'2002-05-01 23:32:28.000'

If select this date from the mssql database, and insert it in a mysql database, in a field with the same datetime properties, I get this result ;
'0000-00-00 00:00:00'

I did not know why, so I tried echoing the value before importing it, to see what it looks like,
and it gave me this result ;

'May 1 2002 11:32PM'

See ? Im missing the seconds... so even if I try to import this date in my mysql database in a datefield format, the date will be screwed anyway, because im missing the seconds.

The problem seams to lie where I actually select the date from the mssql database ... If I could find a mssql function that will automatically transform the date in a unix timestamp value, i'll be able to import the date correcly in my mysql database !

Hope im clear enough ! =)