I am using SELECT CONVERT(VARCHAR(10),GETDATE(),112) it is giving 20080403; ... select [Datetime] = convert(char, getdate(), 0) –mon dd yyyy hh:mmAM (or PM)
確定! 回上一頁