This needs more documentation but I'm tired of remembering this
CAST(ReceiveDate AS NVARCHAR(10)) + ' ' + CAST(ReceiveTime AS NVARCHAR(16))
To make a datettime2:
CONVERT(datetime2, CAST(ReceiveDate AS NVARCHAR(10)) + ' ' + CAST(ReceiveTime AS NVARCHAR(16)))
No comments:
Post a Comment