Advertisement
Guest User

Untitled

a guest
Aug 19th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.16 KB | None | 0 0
  1. CASE
  2.     WHEN CONVERT(VARCHAR(200), A.EffectiveDate, 121) = '1900-01-01'
  3.         THEN NULL
  4.     ELSE CONVERT(VARCHAR(200), A.EffectiveDate, 121)    
  5. END AS TestingDate,
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement