Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and DATEADD
Learn how to work with dates and calculate particular dates or elapsed time periods with some of the functions available in SQL Server.
2025-05-09
2,433 reads
Date Functions
2025-03-03
461 reads
2024-08-02
488 reads
2024-07-08
443 reads
2024-07-03
128 reads
How to Find the Start and End Dates for the Current Week (and more)
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
31,641 reads
PostgreSQL Date And Time Part 2
In the second part of this PostgreSQL date time series, we examine a number of commonly used functions for getting current dates and times and converting strings to dates and times.
2021-09-22
3,434 reads
2021-06-28
717 reads
Blogs
India-US Tariff War: Is the Indian IT Sector at Risk?
By Rohit Garg
How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly...
Save BIG on Microsoft Azure Certification – Up to 100% Off!
By Rohit Garg
🌟 Why Microsoft Azure Certifications Are Beneficial for Your Career 🗓️ How to Schedule...
Modifying a Trigger to Capture More Info: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
Forums
One big server with multiple instances, or multiple smaller servers...
We're currently on SQL 2019 and will likely be looking to migrate to a...
Transitioning AlwaysOn Availability Group to Synchronous Commit Mode
Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas...
CDC & Azure Managed Instances - Performance degredation
Anyone got any good advice for performance tuning CDC on a Managed Instance? We...
Question of the Day
The Trigger Updated Column(s)
In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?
See possible answers