Hi there.

I'm trying to convert, in a Microsoft Sql Server 2008, the field MM2COMPLETEREQUEST from table RequestCharges using the following command but it does not work well. Look:

SELECT RC . MM2COMPLETEREQUEST , DATEADD ( s , RC . MM2COMPLETEREQUEST / 1000 , '1970-01-01 00:00:00.000' ) FROM RequestCharges RC WHERE RC . WORKORDERID = 3887

the result is a date in the year of 1970, but the correct is 2011-12-27

900000   1970-01-01 00:15:00.000
7200000 1970-01-01 02:00:00.000

 

My question is: What I need to do to get the right information ?

 

Since now, thanks a lot.

 

Amarildo Gorzillo

Lincoln Electric Brazil

gorzillo@gmail.com