Advertisement
Guest User

Untitled

a guest
Jul 10th, 2014
223
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. DECLARE @dt DATETIME = '2014-07-07 09:49:33.000';
  2. DECLARE @dto DATETIMEOFFSET(2) = '2014-07-07 09:49:33.00 +07:00';
  3.  
  4. PRINT CASE WHEN @dt = @dto THEN 'Equals matches'
  5. ELSE 'Equals does not match'
  6. END
  7.  
  8. PRINT CASE WHEN @dt = CAST(@dto AS DATETIME) THEN 'Cast matches'
  9. ELSE 'Cast does not match'
  10. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement