Guest User

Untitled

a guest
Jan 19th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. select convert(varchar(20),fmdate) from Sery
  2.  
  3. CONVERT(VARCHAR(10), fmdate(), 101)
  4.  
  5. select convert(varchar(10), fmdate, 101) from sery
  6.  
  7. select convert(varchar(10), cast(fmdate as date), 101) from sery
  8.  
  9. Find All Date Formats for SQL.
Add Comment
Please, Sign In to add comment