Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA@justindavis I found it super helpful to bookmark this link: Date/Time Functions... Click on Specifiers to see the full list of different specifiers for use in the DateTimeFormat or DateTimeParse functions. I refer to this list all of the time!
You might also find the examples in this post helpful in addition to the Weekly Challenges. You're right - the hands-on practice is hugely helpful!
Thanks @kelly_gilbert those are sure to be super helpful! I had found the first one with the list of functions and specifiers, but not the second post, which looks promising. Years of easy conversions in SQL makes it a more difficult transition but I'm sure I can nail it down.
Good practice for date time formatting
Went a little crazy with the data cleaning and formatting of the datetime columns.