Cast() and Convert() Functions in SQL Server

Sign in to leave a comment.

• 

  Sridhar Yelagandhula5y agoPosted May 14, 2021, 8:54 AM

  Nice it's helpful.
• 

  Binod Kumar7y agoPosted Apr 9, 2019, 4:51 AM

  Great Acticle
• 

  Amol Kumbhkarna8y agoPosted May 27, 2018, 1:19 AM

  Great Article...Thanks For Sharing It..
• 

  Subash10y agoPosted Sep 16, 2016, 12:32 AM

  Good one sir
• KR

  kalu singh rao10y agoPosted Jul 3, 2016, 9:02 AM

  Nice...
• SR

  soundara rajan12y agoPosted Oct 28, 2014, 6:21 AM

  very useful RK thanks...
• 

  Abhishek Jaiswal12y agoPosted Jun 29, 2014, 9:40 AM

  That's what I was looking for!
• KK

  kanti khairaliya12y agoPosted Mar 27, 2014, 6:29 AM

  good article
• E

  ermenegildo13y agoPosted Oct 16, 2013, 6:49 PM

  Muy bien pero quisiera saber como se realiza un traiger o disparador en un servido sql server gracias
• 

  Manish Dwivedi13y agoPosted Jul 16, 2013, 12:38 AM

  In the above example suppose @A have value like 'sa' and then we try to cast it as int. Rohtash tell me how will we handle this situation or error.
  • 

    Vijay Pratap Singh3y agoPosted Jan 20, 2023, 12:37 PM

    It will throw an error sir of conversion as cannot cast varchar to int
• 

  Rohatash Kumar13y agoPosted Jul 15, 2013, 11:54 PM

  Thanks mike.
• 

  Rohatash Kumar13y agoPosted Jul 15, 2013, 11:52 PM

  Geoffrey, some time We need different date formats. You can also use your own date format in place of the getdate() function.
• GA

  Geoffrey Ashna13y agoPosted Jul 15, 2013, 2:46 PM

  I have a quick question in regards to the convert function that Rohatash has demonstrated. Why would it be necessary to convert a getdate(), 107 to a varchar(20). Does it provide any significance or was the purpose was just for pure example. By the way, this is an excellent post, just wanted to know on the varchar(20 for the convert function.
• MM

  Mike Mike13y agoPosted Dec 16, 2012, 2:21 PM

  In my opinion, Rohatash Kumar's article is the best.