How to Format Dates in SQL Server using Convert and Format
9.4 هزار بار بازدید -
3 سال پیش
-
Date formatting is one of
Date formatting is one of the key skills you’ll learn as you progress as a data engineer. In the old days, it could be a hassle for you to get a particular format. Every country and client site seems to use a different format, and it can wreak havoc with even well-written code. For SQL Server, things have gotten better since SQL Server 2012, when a new function called “Format” started to be used alongside the traditional way of getting date formats which is a function called “Convert”. Find out these two ways of formatting your dates in this episode!
Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :
www.patreon.com/mackenziedataengineering
Demo of my BZ RDP Cloaker:
www.patreon.com/posts/how-to-block-rdp-98471703?ut…
Want to work with me 1:1? Contact me today and book your free 20 min consultation!
Contact form you can find at www.mackenziemackenzie.com/
Follow me on social media:
www.facebook.com/mackenziedataanalytics
twitter.com/seamacke
www.instagram.com/seamacke/
www.reddit.com/user/seamacke
www.linkedin.com/in/psmackenzie/
Get Microsoft Office including Access:
click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&…
Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy.com/seanmackenziedataengineering
For developers looking for a new role, check out:
www.toptal.com/qKaO2b/worlds-top-talent
Want my team to do a project for you? Let's get to it!
system.billzone.com/smdeprojects.html
#FormatDates #SQLServer
• How to Format Dates in SQL Server usi...
3 سال پیش
در تاریخ 1400/04/11 منتشر شده
است.
9,469
بـار بازدید شده