Skip to content
April 1, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Event Free Live Training Virtual Symposium DPD banglore
  • Free Courses
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes by Amit Bansal (AB)
  • About Us
    • Subscribe To Our Newsletter
    • Social Channels
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Tag: DATEPART

SQL Server / SQL Server Accidental DBA Series

SQL function to get weekday – weekly calendar

April 10, 2015December 20, 2019 - by SQL Geek - Leave a Comment

In this blog post we’ll look at a way to list out all week days of a week a particular date belongs too. This can be even referred to as weekly …

SQL function to get weekday – weekly calendar Read More
SQL Server / SQL Server Accidental DBA Series

SET DATEFIRST in SQL Server

December 17, 2014December 20, 2019 - by SQL Geek - Leave a Comment

The SET DATEFIRST function is used to set the first day of the week from number 1-7. In order to know the current first day of the week, @@DATEFIRST is used. …

SET DATEFIRST in SQL Server Read More
SQL Server / SQL Server Accidental DBA Series

Function to Extract Month from Date in SQL Server

December 1, 2014December 20, 2019 - by SQL Geek - Leave a Comment

A function to extract month from date is a most common question in forums. Month part from a date can be extracted as shown below SELECT MONTH(GETDATE()) AS [Month] GO SELECT …

Function to Extract Month from Date in SQL Server Read More
SQL Server / SQL Server Accidental DBA Series

SQL Function to Extract Year from Date

November 29, 2014December 20, 2019 - by SQL Geek - Leave a Comment

One of the most asked questions in forums and discussion board is how a SQL function to extract year from date. This can be done in multiple ways as shown below. …

SQL Function to Extract Year from Date Read More

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.