Skip to main content

Add as a preferred source on Google


4 New T-SQL Functions: Listing 1.

Using TRY_CONVERT with the Style parameter.

  • By Sam Nasr
  • 01/01/2013
select TRY_CONVERT(varchar(50), '08/18/2012', 1) as NewResult
NewResult
09/08/12

select TRY_CONVERT(varchar(50), '08/18/2012', 2) as NewResult
NewResult
12.09.08

select TRY_CONVERT(varchar(50), '08/18/2012', 3) as NewResult
NewResult
08/09/12

select TRY_CONVERT(varchar(50), '08/18/2012', 4) as NewResult
NewResult
08.09.12

select TRY_CONVERT(varchar(50), '08/18/2012', 5) as NewResult
NewResult
08-09-12

About the Author

Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. Having achieved multiple certifications from Microsoft (MCAD, MCTS(MOSS), and MCT), Sam develops, teaches, and tours the country to present various topics in .Net Framework. He is also actively involved with the Cleveland C#/VB.Net User Group, where he has been the group leader since 2003. In addition, he also started the Cleveland WPF Users Group in June 2009, and the Cleveland .Net Study Group in August 2009, and is the INETA mentor for Ohio. When not coding, Sam loves spending time with his family and friends or volunteering at his local church. He can be reached by email at [email protected].

comments powered by Disqus

Featured

  • Mastering AI Development and Building AI Apps with GitHub Copilot

    Two Microsoft experts explain how GitHub Copilot is evolving from a coding assistant into a broader platform for building, customizing and testing AI-powered developer workflows.

  • VS Code 1.123 Adds Agent Session Sync, 1M Context Windows

    Microsoft released Visual Studio Code 1.123 on June 3, adding agent-focused features, larger model context support, integrated browser updates and a new delay for some automatic extension updates.

  • Copilot Billing Shock Hits Developers

    Developer complaints about GitHub Copilot's new usage-based billing model have centered on unexpectedly rapid AI credit consumption, and neither GitHub nor Microsoft has responded directly to the backlash, though they have previously published guidance to lessen model usage costs.

  • Hands On with GitHub Copilot App Technical Preview: Turning a Blazor Issue into a PR

    GitHub's brand-new Copilot desktop app, in technical preview, handled a small Blazor issue from planning through pull request creation, but the hands-on test also showed why developers still need to verify agent work in the running app before merging.

Most   Popular

Subscribe on YouTube