i tried convert but the results are still the same ..

select STATUS,INTERNAL_STATUS,STATE,LAST_SUCCESSFUL_STATE ,DOCTYPEID,CONVERT(DATETIME,receivedate,126) receivedate, COUNT(1)

from document

where DOCTYPEID='ORDERS'

and sendermailboxid = 'GIANT_MAL' -- note: xxx is the name of the senderid, here...