Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @dt DATETIME = '2014-07-07 09:49:33.000';
- DECLARE @dto DATETIMEOFFSET(2) = '2014-07-07 09:49:33.00 +07:00';
- PRINT CASE WHEN @dt = @dto THEN 'Equals matches'
- ELSE 'Equals does not match'
- END
- PRINT CASE WHEN @dt = CAST(@dto AS DATETIME) THEN 'Cast matches'
- ELSE 'Cast does not match'
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement