I think I can do that.
Hmmm... Lets See....
SELECT distinct
CONVERT(VARCHAR(15),GAP.GAPGatePassDate,101) as [Date],
CONVERT(VARCHAR(15),GAP.GAPGatePassDate,108) as [Time],
VCO.VCOContainerNo as [Container No],
CON.CONSizeCode as [Size],
CON.CONTypeCode as [Type]...